I am trying to locate the position of a substring in a string field in omnibus.
eg: If the string is 'Hello my name is XYZ', I want to find the location (or index) of XYZ.
I should get the index as 17.
I have tried functions like charindex, patindex, instr, locate. All of them give errors.