Skip to Content

Turn your connections into holiday cash with our new Customer Referral Program! Learn more

✕

This documentation is for version 4 of App Builder, the new name for Vinyl. Access the Vinyl documentation here.

✕

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