Okay guys i must have done this a million times but i am feeling brain dead today.
I have 1 textbox in the user interface that allows the user to enter search criteria and search a couple of columns in our database in 1 table.
The code that I was using looked like this
(assuming @pisearchtext = "rainy day")
select * from blah blah blah
tick.descriptionStripped like '%' + @piSearchText + '%'
or tick.title like '%' + @piSearchText + '%'
or tick.ticketnumber like '%' + @piSearchText + '%'
or tick.keywords like '%' + @piSearchText + '%'
What if i want to search for each word individually however?
I want to locate either the word 'rainy' or 'day' and not 'rainy day' together.
If i knew there were 2 words i could for example write this where clause
tick.descriptionStripped like '%rainy%' or tick.descriptionstripped like '%day%'
I am trying to do this without full text indexing.