SQL Server/T-SQL Tutorial/String Functions/CHARINDEX

CHARINDEX returns the starting point of the first occurrence of one string within another string.

A value of 0 is returned if the string is not found.
CHARINDEX does not take into account whether the strings are upper or lower case.
8> DECLARE @STRING_TO_SEARCH_FOR varchar(4)
9> DECLARE @STRING_TO_SEARCH_WITHIN varchar(100)
10> SET @STRING_TO_SEARCH_FOR = "sqle.ru"
11> SET @STRING_TO_SEARCH_WITHIN = "sqle,sqle.ru, www.sqle.ru"
12> SELECT CHARINDEX(@STRING_TO_SEARCH_FOR, @STRING_TO_SEARCH_WITHIN, 6)
13> GO
-----------
          8
(1 rows affected)

Finding the Start Position of a String Within Another String

4>
5> SELECT CHARINDEX("String to Find", "This is the bigger string to find something in.")
6> GO
-----------
         20
(1 rows affected)
1>

Get index of the delimiting space

4> DECLARE @FullName VarChar(25), @SpaceIndex TinyInt
5> SET @FullName = "George"
6>
7> -- Get index of the delimiting space:
8> SET @SpaceIndex = CHARINDEX(" ", @FullName)
9>

select CHARINDEX("-", "(1212")

2> select CHARINDEX("-", "(559) 555-1212")
3> GO
-----------
         10
(1 rows affected)

SELECT CHARINDEX("Mars", "The stars near Mars are far from ours")

4> SELECT CHARINDEX("Mars", "The stars near Mars are far from ours")
5> GO
-----------
         16
(1 rows affected)
1>

select CHARINDEX("SQL", " SQL Server")

2> select CHARINDEX("SQL", " SQL Server")
3> GO
-----------
          2
(1 rows affected)