SQLBill
I have tried this by copying it to Query analyzer v7 but i get the following
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'ab'cd)
SELECT @mystring
SELECT PATINDEX('.
Server: Msg 105, Level 15, State 1, Line 5
Unclosed quotation mark before the character string ', @mystring)
Any ideas? All I want to find is anything such as "can't" within the string.
Lewis
United Kingdom