SQL Server Hosting – HostForLIFE.eu :: Check If A String Contains A Substring In SQL Server

In this blog, I wil explain how to check a specific word or character in a given statement in SQL Server, using CHARINDEX function or SQL Server and check if the string contains a specific substring with CHARINDEX function.
Alternative to CHARINDEX() is using LIKE predicate.

Method 1
 
Using CHARINDEX() function

CHARINDEX()
This function is used to search for a specific word or a substring in an overall string and returns its starting position of match. In case no word is found, then it will return 0 (zero).

Let us understand this with examples.

Syntax

CHARINDEX ( SearchString,WholeString[ , startlocation ] )

Example

Output
1

Method 2

Using LIKE Predicate

Output

2