LTRIM Function


Function Type

Predefined function

Syntax

LTRIM( <stringValue> )

Description

Returns <stringValue> with its leading (left most) spaces removed.

Argument

Description

<stringValue>

String value to be trimmed.

Returns

String

Example

This example removes the leading spaces from the string "TestString".

LTRIM(" TestString")

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI DevX Data Studio Help