Character Functions

These functions operate on character data.

Functions
$ Operator
ALLTRIM( ) Function
ASC( ) Function
AT( ) Function
AT_C( ) Function
ATC( ) Function
ATCC( ) Function
ATCLINE( ) Function
ATLINE( ) Function
BETWEEN( ) Function
CHR( ) Function
CHRTRAN( ) Function
CHRTRANC( ) Function
CPCONVERT( ) Function
CTOD( ) Function
DIFFERENCE( ) Function
DTOC( ) Function
EMPTY( ) Function
EVALUATE( ) Function
GETWORDCOUNT( ) Function
GETWORDNUM( ) Function
INLIST( ) Function
ISALPHA( ) Function
ISDIGIT( ) Function
ISLEADBYTE( ) Function
ISLOWER( ) Function
ISUPPER( ) Function
LEFT( ) Function
LEFTC( ) Function
LEN( ) Function
LENC( ) Function
LIKE( ) Function
LIKEC( ) Function
LOWER( ) Function
LTRIM( ) Function
MAX( ) Function
MIN( ) Function
NORMALIZE( ) Function
OCCURS( ) Function
PADL( ) \| PADR( ) \| PADC( ) Functions
PROPER( ) Function
RAT( ) Function
RATC( ) Function
RATLINE( ) Function
REPLICATE( ) Function
RIGHT( ) Function
RIGHTC( ) Function
RTRIM( ) Function
SOUNDEX( ) Function
SPACE( ) Function
STR( ) Function
STRCONV( ) Function
STRTOFILE( ) Function
STRTRAN( ) Function
STUFF( ) Function
STUFFC( ) Function
SUBSTR( ) Function
SUBSTRC( ) Function
SYS(10) - String from Julian Day Number
SYS(15) - Character Translation
SYS(2007) - Checksum Value
TEXTMERGE( ) Function
TRANSFORM( ) Function
TRIM( ) Function
TXTWIDTH( ) Function
TYPE( ) Function
UPPER( ) Function
VARTYPE( ) Function

See Also