String Verification and Formatting
These functions carry out string formatting tasks.
- To do this...
- Use this...
- Check if a string is alphabetic
- Alpha Function
- Verify with a 16-bit checksum
- Checksum Function
- Verify with a 32-bit cyclic redundancy check code
- CRC32 Function
- Enclose a string in double quotation marks
- DQuote Function
- Enclose a string in single quotation marks
- SQuote Function
- Analyze a string phonetically
- Soundex Function
- Convert a string to uppercase
- UpCase Function
- Convert a string to lowercase
- DownCase Function
- Replace specified characters in a variable
- Convert Function
- Replace specified characters in a string
- Convert Statement
- Replace or delete characters in a string
- Exchange Function
- Compare two strings for equality
- Compare Function
- Calculate the number of characters in a string
- Len Function
- Calculate the length of a string in display positions
- LenDP Function
- Trim surplus white space from a string
- Trim Function TrimB Function TrimF Function
- Make a string consisting of spaces only
- Space Function