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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.