cheers guys,
i did want it in sql
but i already had a function in place that split the string in the vb.net side

then i run the stored procedure on each word.
basically i am worried i am making an error on this process being 'heavy work'

i.e. if the string has 15 words, i have to execute that stored procedure 15 times - program side.

but i suppose i would have to check each word individually anyway to acheive this