REGEXP_INSTR Function Examples | VantageCloud Lake - REGEXP_INSTR Function Examples - Teradata Vantage

SELECT REGEXP_INSTR('Hello Santa says ho ho','Hello Santa says ho ho', 1, 1, 1, 'c');

Output:

23

SELECT REGEXP_INSTR('Hello Santa says ho ho', 'Hello Santa says ho ho', 1, 1, 0, 'c');

Output:

1