Check if a string contains a substring in SQL Server 2005 using a stored procedure

Question

I ve a string   mainString    CATCH ME IF YOU CAN   I want to check whether the word ME is inside  mainString   How do I check if a string has a specific substring in SQL

User · Accepted Answer

CHARINDEX   searches for a substring within a larger string  and returns the position of the match  or 0 if no match is found if CHARINDEX  ME   mainString   gt  0 begin     --do something end  Edit or from daniels answer  if you re wanting to find a word  and not subcomponents of words   your CHARINDEX call would look like  CHARINDEX   ME         REPLACE REPLACE  mainString                            Add more recursive REPLACE   calls for any other punctuation that may occur

User · Answer

You can just use wildcards in the predicate  after IF  WHERE or ON     mainstring LIKE        substring         or in this specific case         mainstring       LIKE    ME           Put the spaces in the quoted string if you re looking for the whole word  or leave them out if ME can be part of a bigger word

[sql-server] Check if a string contains a substring in SQL Server 2005, using a stored procedure

Examples related to sql-server

Examples related to string

Examples related to tsql

Examples related to stored-procedures

Examples related to sql-server-2005