STRFIND

Use the @STRFIND function to determine the position of a string within a string column or else return zero if the string is not found. Optionally, @STRFIND can accept a starting position within the string.

For this function, Oracle GoldenGate supports the use of an escape sequence to represent characters in a string column in Unicode or in the native character encoding of the Microsoft Windows, UNIX, and Linux operating systems. The target column must be a SQL Unicode data type if any argument is supplied as Unicode.

This function does not support NCHAR or NVARCHAR data types.

Syntax

@STRFIND (string, 'search_string' [,  begin_position])
string

The string in which to search. This can be either the name of a character column or a literal string that is within single quote marks.

'search_string'

The string for which to search. Enclose the search string within single quote marks.

begin_position

The byte position at which to begin searching.

Example

Assuming the string for the ACCT column is ABC123ABC, the following are possible results.

Function statement Result 
@STRFIND (ACCT, '23')
5 
@STRFIND (ACCT, 'ZZ')
0 
@STRFIND (ACCT, 'ABC', 2)
7 (because the search started at the second byte)