Character Functions

These functions operate on Character data.

$ 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

INLIST( ) Function

ISALPHA( ) Function

ISDIGIT( ) Function

ISLEADBYTE( )

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

PADC( ) Function

PADL( ) Function

PADR( ) Function

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) Function - String From Day Number

SYS(15) Function - Character Translation

SYS(2007) Function - Check Sum Value

TRANSFORM( ) Function

TRIM( ) Function

TXTWIDTH( ) Function

TYPE( ) Function

UPPER( ) Function

VARTYPE( ) Function