The LOCATE function returns the starting position of the first occurrence of search- string within   source-string

Example  :

Exec Sql Select Locate(‘N’, ‘NASHVILLE’)

From Sysibm/Sysdummy1;

Result is 1