Reference Guide
>
TDV Support for SQL Functions
>
Character Functions
>
LOCATE
LOCATE
Returns the position of the first occurrence of a substring in a string.
Syntax
LOCATE(substring, string, start)
Example
SELECT LOCATE(‘Virtual’, ‘Data Virtualization’,1)
Returns:6