SQL iQuery Script Built-in Functions

Trim Characters from Left Side


The trimLeft() built-in functions returns the value specified on the first parameter with the characters specified on the 2nd parameter removed from the left side of the value.Syntax

The timeLeft built-in function returns the contents of the first parameter after removing all characters specified on parameter 2 or blanks if no parameter 2 is specified. Use this built-in function to left-justify data within a session variable.


  1. Variable or quoted character string whose content is trimmed.
  2. A list of characters to be removed from the left side of the value in parameter 1. If this parameter is omitted, blanks are trimmed.
eval &comment = '  Some other time.';
eval &comment = trimLeft(&comment);
#msg The Comment is "&Comment"

The output written to the joblog is:

The Comment is "Some other time."