sivajii (9/3/2012)
here i used CROSS APPLY dbo.DelimitedSplit8k(@VALUES,'')ds funtion to split the words 'the cri word'
declare @value varchar(800)='the cri word'
function name is split it will split values like this
the
cri
word
this words should be checked one by one in the select query
Your problem above is you passing in the empty string as a delimiter. That just isn't going to work. If the words are delimited by spaces, then pass in a space like this:
CROSS APPLY dbo.DelimitedSplit8k(@VALUES,' ')ds