LeftSide

Summary

The LeftSide function returns the first n characters of the input string.

Syntax

LeftSide(<string>, <integer>)

Return Type

String

Details

The integer input parameter index begins at 1.

Examples

select LeftSide(‘abcdefg’, 3) as LeftSide_example
from Empty();

screen-shot-2016-09-14-at-12-00-05-pm

 

select LeftSide(first_name, 4) as LeftStr_example,
first_name
from xactly.xc_participant;

screen-shot-2016-09-14-at-11-59-57-am

Related Functions

Ltrim

RightSide

Rtrim