Database Tour Documentation
pos function

Category:

Miscellaneous

Returns position of a substring in a string.

Syntax

pos(
  SubStr String,
  Str String
): Integer

Parameters

SubStr is the substring to find.

Str is the string to search.

Return value

Type: Integer. If the substring found, the function returns one-based index of the first occurrence of SubStr in Str, otherwise 0 is returned.

Examples of using

pos('Important', dataset_field_val(1, 'Subject'))