LTRIM

Purpose

The LTRIM function deletes all of the characters specified in the expression trim_chars from the left border of string.

Syntax

ltrim::=

Usage Notes

  • If parameter trim_chars is not specified, spaces are deleted.

Example

Copy 
SELECT LTRIM('ab cdef',' ab');