Steve,

'Like' is similar to the foxpro like() function, and 'charindex' is at() equivalent. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_3ins.asp for more details on charindex.



>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.