Check if a string contains a substring in SQL Server 2005 Stored Procedure
- by NLV
Hello
I've a string @mainString = 'CATCH ME IF YOU CAN'. I want to check whether the word 'ME' inside @mainString.
So how to check if a string has a substring in sql?
Thank you
Regards
NLV