Alll words search

[Hameedullah]

I am trying to do a search to find records that have all words in the the same field not necessary as a phrase. This is the quuery I am trying but it doesn't work.

select descr, link, keyword from dbo.keywords where  keyword like '%broadband%' and keyword like '%adsl%'

As far as I can think this sould bring all the records that these two words occur in any position in the keyword feild.

 

[amrita418]

I do not see any problem with the code. Why do you think that the query is not working? Can you post some sample data?

Regards,
AA

 

[Hameedullah]

got it sorted... Thanks!