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

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

  • Last updated on