strip

Strips the leading and trailing characters from the first argument. The optional second argument defines the set of characters to strip. By default, this function strips white space (ie. space, tab, carriage return and line feed).

Note: Supported only in dynamic query mode.

Syntax

strip ( string_expression [ , set_of_characters ] )

Example 1

# sq( strip ( '    abc  ' ) ) #

Result

'abc'

Example 2

' ) #

Result

53.21