LOCATE (string1, string2 [, start ])

Returns the starting position of the first occurrence of string1 within string2. The search within string2 begins at the first character position unless you specify a starting position (start). The search begins at the starting position you specify. The first character position in string2 is 1. The string1 is not found, the function returns the value zero.

The following example results in the first name trimmed to three characters beginning from left, the length as 9 and locate results 0. This query results in "Roo", 9, 0

SELECT LEFT(First_name, 3),LENGTH(First_name), LOCATE(First_name, 'a') FROM Person WHERE First_name = 'Roosevelt'
Thursday, 18 April 2019 Posted in String Functions