Introduction 3
Functions That Change the Case of Characters 5
UPCASE 6
LOWCASE 7
PROPCASE 9
Functions That Remove Characters from Strings 11
COMPBL 11
COMPRESS 13
Functions That Search for Characters 16
ANYALNUM 17 NOTUPPER 27
ANYALPHA 18 FIND 29
ANYDIGIT 19 FINDC 31
ANYPUNCT 20 INDEX 34
ANYSPACE 21 INDEXC 36
NOTALNUM 24 INDEXW 39
NOTALPHA 25 VERIFY 41
NOTDIGIT 26
Functions That Extract Parts of Strings 43
SUBSTR 43
SUBSTRN 49
Functions That Join Two or More Strings Together 51
CALL CATS 52 CATS 57
CALL CATT 53 CATT 58
CALL CATX 53 CATX 59
CAT 56
Functions That Remove Blanks from Strings 61
LEFT 61 TRIMN 66
RIGHT 63 STRIP 68
TRIM 64
Functions That Compare Strings (Exact and "Fuzzy" Comparisons) 70
COMPARE 70 COMPLEV 76
CALL COMPCOST 73 SOUNDEX 81
COMPGED 74 SPEDIS 84
Functions That Divide Strings into "Words" 89
SCAN 89
SCANQ 90
CALL SCAN 95
CALL SCANQ 98
Functions That Substitute Letters or Words in Strings 100
TRANSLATE 100
TRANWRD 103
Functions That Compute the Length of Strings 105
LENGTH 105
LENGTHC 106
LENGTHM 106
LENGTHN 107
Functions That Count the Number of Letters or Substrings in a String 109
COUNT 109
COUNTC 111
Miscellaneous String Functions 113
MISSING 113
RANK 115
REPEAT 117
REVERSE 119