Function documentationLTRIM(x,y) Locate this document in the navigation structure

 

LTRIM(x,y) is a string function that removes all of the characters specified in the character string y (string specification) from the start of the character string x.

The result of LTRIM(x,y), therefore, starts with the first character that was not specified in y. Only expressions that produce an alphanumeric value are permitted as string specifications.

LTRIM(x,y)

x, y

Result of the LTRIM(x,y) function

LTRIM(x)

Spaces only (code attribute ASCII, UNICODE) are removed from x.

x is a NULL value

NULL value

Example

SQL Tutorial, Changing Character Strings

More Information

TRIM(x,y)

RTRIM(x,y)