Left() mvSQL database function in Jitterbit App Builder

Summary

Returns a given number of characters from the left side of a supplied text string.

Syntax

LEFT(<string>, <numchars>)

Parameters

string

The string to evaluate.

numchars

The numer of left-most characters to return.

Returns

A given number of characters from the left side of a supplied text string.

Examples

LEFT('ABCDEF', 3)

Returns

ABC