sql like query

[nikhil1234]

in my application i have provided name search i am using like Claus if user enter jhone lee and name contains jhone then i am getting correct result but if enters lee jhone then also i want record to display my sql query is select name from names where name like '%jhone lee%' correct result select name from names where name like '%lee jhone %' correct result plz tell me sql

[Abhijit Jana]

nikhil1234 wrote:

plz tell me sql

First of all This is ASP.NET Forum. And you question is related to SQL :)

nikhil1234 wrote:

select name from names where name like '%jhone lee%' correct result select name from names where name like '%lee jhone %' correct result plz tell me sql

Then why you are not trying this:

select name from names where name like 'jhone %'

:)

cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net View My Recent Article

[Manas Bhardwaj]

You can take this as an example:

DECLARE @Delimitedtext varchar(max);
DECLARE @Delimiter char(1);
SET @Delimitedtext = 'Manas Bhardwaj';
SET @Delimiter = ' ';

DECLARE @FName nvarchar(max)
DECLARE @LName nvarchar(max)

SELECT
@FName = SUBSTRING(@Delimitedtext,1, CHARINDEX(@Delimiter, @Delimitedtext)-1),
@LName = SUBSTRING(@Delimitedtext,CHARINDEX(@Delimiter, @Delimitedtext)+1, len(@Delimitedtext))

Select
[name]
from
names
where
[name] like '%' + @FName + '%'
or
[name] like '%' + @LName + '%'

I have assumed here that the name will always be comprised of FirstName and LastName. :rose:

Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.