LEFT(S, N)

 

Description

This function returns the string composed of the leftmost characters of string S.  If N is greater than or equal to the length of S, then the entire string S is returned.

 

Parameters

 

S

A string value.

 

N

A numeric value.

 

Examples

 

Given:

 

F1 = "workstation"

 

LEFT(F1, 1) = "w"

 

LEFT(F1, 4) = "work"

 

LEFT(F1, 20) = "workstation"