Here’s a case-sensitive search: SELECT CHARINDEX('Beer', 'Bob likes beer.' COLLATE Latin1_General_CS_AS) You can explicitly perform a case-sensitive search by adding the COLLATE clause to your SELECT statement: Case-Sensitive And we can see that its position is 17 characters from the start of the string (even though it’s only one character from where we started searching). So in this example we start searching at position 16 (which happens to be the space before the 2nd Bob). The result is that the first occurrence of Bob is skipped, and the second one’s position is returned. If this sounds confusing, the following example should help: SELECT CHARINDEX('Bob', 'Bob likes beer. However, the results are still reported based on its position within the string (not from the start position). This means that SQL Server will skip any occurrence that comes before that starting position. You can specify a starting position for where to start searching. SELECT CHARINDEX('Kate', 'Bob likes beer.

If the second argument didn’t contain Bob the result would’ve been 0. You might also notice that Bob actually appears twice in the string, but only the position of the first match is returned. The result is 1 because that’s the position where Bob first appears in the second argument. In this example, the first argument is Bob, which means that we’re searching the second argument for Bob. Here’s an example: SELECT CHARINDEX('Bob', 'Bob likes beer. Note that only the position of the first occurrence is returned. The optional start_location can be used to specify a position within expressionToSearch for which to start searching. Where expressionToFind is the expression you want to find in the other string, and expressionToSearch is the other string. The CHARINDEX() syntax goes like this: CHARINDEX ( expressionToFind, expressionToSearch ) This function accepts 3 arguments the string to find, the string to search, and an optional start position.

Here’s a quick overview of each function. In SQL Server, you can use the T-SQL CHARINDEX() function or the PATINDEX() function to find a string within another string.

What is string in sql