>Thanks Naomi,
>
>This works for my problem, but sometimes I have to look in a string of values.
>It would be nice if there was a way to loom in a string of values.
>
>Gary
>
I suggest to convert the string of values into a table using any of the split functions available online.
Say, check
http://www.sqlservercentral.com/articles/Tally+Table/72993/
If it's not broken, fix it until it is.
My Blog