Create Function to select record that match the string by replacing specific character in SQL Server

jordan

SOLVED CLOSED ACTIVE ANSWERED
User: jordan
Posted: on Apr 06, 2017 02:05 AM
Forum: SQL Server
Answer: 1
Views: 2842

i have to match string like below

i have store cow dog

there is space between them cow-----dog

---this indicate space

when i search like cowdog it will show me that name which hhave space

when i search cowd i

then also it will show me cowdog

i want to write query using scalar function

Indresh

0 1

Reply
ANSWER
User: Indresh
Replied: on Apr 06, 2017 04:33 AM
Modified: on Apr 06, 2017 04:43 AM
Report

Hi jordan,

Please refer the below sql query.

Scalar function

CREATE FUNCTION SearchResult(@Search VARCHAR(50)) 
RETURNS  VARCHAR(50) 
AS
BEGIN

    DECLARE @Result VARCHAR(50);
    SELECT @Result= Name FROM Customers
                    WHERE REPLACE(Name,' ', '') Like '%'+ REPLACE(@Search,' ','') + '%'
    RETURN @Result;
END
GO

Create Function to select record that match the string by replacing specific character in SQL Server

Company

Explore

Follow us

Contact Us