TSQL Search on String
Posted on 2010-09-17
I would like to create a stored proc that would search on the exact term keyed in (could be one word or phrase and then search on the seperate words in the phase:
Sample Search "Experts Exchange"
WHERE = like 'experts exchange' OR like 'experts' OR like 'exchange'
What is the best practice for this (speed etc)? Im going to take out all stop words so I just get a search on only the keywords typed.