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

by

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) > 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)

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  3. T-SQL stored procedure that accepts multiple Id values
  4. Check if table exists in SQL Server
  5. Sql Server string to date conversion
  6. Select columns from result set of stored procedure
  7. How to get Time from DateTime format in SQL?
  8. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  9. Escape a string in SQL Server so that it is safe to use in LIKE expression
  10. Better techniques for trimming leading zeros in SQL Server?
  11. How much size “Null” value takes in SQL Server
  12. best way to convert and validate a date string
  13. Find index of last occurrence of a sub-string using T-SQL
  14. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  15. SQL Server ORDER BY date and nulls last
  16. EXEC sp_executesql with multiple parameters
  17. T-SQL Dynamic SQL and Temp Tables
  18. How to remove accents and all chars a..z in sql-server?
  19. Find non-ASCII characters in varchar columns using SQL Server
  20. WHERE clause on SQL Server “Text” data type
  21. SQL Server error on update command – “A severe error occurred on the current command”
  22. Aggregate bitwise-OR in a subquery
  23. SQL server schema and default schema
  24. SQL to find first non-numeric character in a string
  25. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  26. Eliminate and reduce overlapping date ranges
  27. Does query plan optimizer works well with joined/filtered table-valued functions?
  28. What are row, page and table locks? And when they are acquired?
  29. @@ERROR and/or TRY – CATCH
  30. SQL Server stored procedure return code oddity

Leave a Comment