Yuri,

What is the difference in the LIKE and CHARINDEX? I cannot find any documentation on the charindex function. What I really need is to be able to type in several words in an edit box and then make a SPT statement that will use these words to find records where matches are made. Sort of like the search on the web.