>Yes it does :o) Thank you! The methods that work (allowing for spaces) is the charindex method and this one.
>
>Now the question is, which is more efficient? Using Stefan's carindex method or this one? This will be part of a maintenance routine and there will could be thousands of records that match.

Either of them is not optimizable and will have to go through all the records in the table unless you have some additional conditions. Only tests can tell wich one will be faster.