@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)