Skip to Content

Position() mvSQL database function in Jitterbit App Builder

Summary

Returns the position of a substring within a string, with 1 being the leftmost character in the main string.

Syntax

POSITION(<substring>, <string>)

Parameters

substring

The substring to find.

string

The string to search through.

Returns

The position of a substring within a string, with 1 being the leftmost character in the main string. Returns 0 if the search string is not found.

Examples

POSITION('lo', 'HelloWorld')

Returns

4