query to search even when user skips in between text

[kkshansid]

i have a database as
table name school
field name location
eg in location column data
green school,tagore garden,chink road,jammu
i want to make search on location such that when user enter
green
green school, tagore
search words should come continous
problem
on skipping in between text
eg on entering
green school, jammu
record not show
search query is

select*from school where location like'%a%'
plz suggest me query to search even when user skips in between text

[ck9663]

Use the PATINDEX() function.

-- CK

[kkshansid]

Use the PATINDEX() function.

-- CK

no patindex is also not working when user skips in between text

[ck9663]

Tweak this code

declare @str as varchar(100)
declare @str1 as varchar(50)

set @str = 'green school,tagore garden,chink road,jammu'
set @str1 = 'tagore garden,jammu'
set @str1 = '%' + replace(@str1,',','%') +'%'
select patindex(@str1, @str)


set @str = 'green school,tagore garden,chink road,jammu'
set @str1 = 'green school,jammu'
set @str1 = '%' + replace(@str1,',','%') +'%'
select patindex(@str1, @str)

-- CK

[kkshansid]

Tweak this code

declare @str as varchar(100)
declare @str1 as varchar(50)

set @str = 'green school,tagore garden,chink road,jammu'
set @str1 = 'tagore garden,jammu'
set @str1 = '%' + replace(@str1,',','%') +'%'
select patindex(@str1, @str)


set @str = 'green school,tagore garden,chink road,jammu'
set @str1 = 'green school,jammu'
set @str1 = '%' + replace(@str1,',','%') +'%'
select patindex(@str1, @str)

-- CK

thank u so much for your guidance now its working