Character string operators

Character string operators allow you to work with and manipulate character strings.

Table 1. Character string operators

Operator	Description
ASCII	The ASCII operator produces a character from its ordinal value.
COLUMN	The COLUMN operator generates blanks.
Concatenate (||)	The || operator makes a string concatenation.
Substring ([s,e])	The [] (square brackets) operator extracts a substring from a variable.
USING	The USING operator converts date and numeric values to a string based on a formatting mask.
CLIPPED	The CLIPPED operator removes trailing blank spaces (ASCII 32) of a string expression.
ORD() [function]	The ORD() operator returns the code point of a character in the current locale.
SPACES	The SPACES operator returns a character string with blanks.
LSTR() [function]	The LSTR() operator returns a localized string.
SFMT() [function]	The SFMT() operator replaces place holders in a string with values.