POSITION(string_exp IN string_exp)

Returns the starting position (one based) of the first character expression in the second character expression.

 

Example:

SELECT POSITION('CDE' IN 'ABCDEFG') returns 3