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