chuang4630
asked on
What is the easiest way to test if a target string 'ABC' is in the source string @sourceString?
What is the easiest way to test if a target string 'ABC' is in the source string @sourceString?
This is for SQL 2005
This is for SQL 2005
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
SQL gives me the error at this line
if (@PONumber like '%-PF-%')
if (@PONumber like '%-PF-%')
ASKER
I got it. Thanks
select * from yourtablename
where sourceColumn like '%ABC%'