Use of SQL charindex functions

There are a lot of functions in SQL, and the following is an introduction to the SQL Charindex function, which hopefully will help you better learn how to use SQL functions.

The SQL charindex function returns the starting position of a character or string within another string. The CHARINDEX function call method is as follows:

CHARINDEX (expression1, expression2 [, Start_location])

Expression1 is the character to look for in expression2, Start_location is where the CHARINDEX function begins to find expression2 in expression1.

The SQL charindex function returns an integer that returns an integer that is the position of the string to find in the string being searched. If the SQL Charindex function does not find the string to find, then the function integer "0". Let's take a look at the result of the following function command execution:

CHARINDEX (' sql ', ' Microsoft SQL Server ')

This function command returns the starting position of SQL in Microsoft SQL Server, in which case the CHARINDEX function returns "S" in Microsoft SQL Server location 11.

Next, let's look at this charindex command:

CHARINDEX (' 7.0 ', ' Microsoft SQL Server 2000 ')

In this example, CHARINDEX returns zero because the string "7.0" cannot be found in Microsoft SQL Server.

Use of SQL charindex functions