ALLTRIM() | Removes leading and trailing blank spaces from a string |
ASC() | Returns the ASCII value of a character |
AT() | Locates the position of a substring in a main string. |
CHR() | Converts an ASCII value to it character value |
HARDCR() | Replace all soft carriage returns with hard carriages returns. |
HB_ANSITOOEM() | Convert a windows Character to a Dos based character |
HB_OEMTOANSI() | Convert a DOS(OEM) Character to a WINDOWS (ANSI) based character |
HB_VALTOSTR() | Converts any scalar type to a string. |
ISALPHA() | Checks if leftmost character in a string is an alphabetic character |
ISDIGIT() | Checks if leftmost character is a digit character |
ISLOWER() | Checks if leftmost character is an lowercased letter. |
ISUPPER() | Checks if leftmost character is an uppercased letter. |
LEFT() | Extract the leftmost substring of a character expression |
LEN() | Returns size of a string or size of an array. |
LOWER() | Universally lowercases a character string expression. |
LTRIM() | Removes leading spaces from a string |
MEMOTRAN() | Converts hard and soft carriage returns within strings. |
PADC() | Centers an expression for a given width |
PADL() | Left-justifies an expression for a given width |
PADR() | Right-justifies an expression for a given width |
RAT() | Searches for a substring from the right side of a string. |
REPLICATE() | Repeats a single character expression |
RIGHT() | Extract the rightmost substring of a character expression |
RTRIM() | Remove trailing spaces from a string. |
SPACE() | Returns a string of blank spaces |
STR() | Convert a numeric expression to a character string. |
STRTRAN() | Translate substring valuw with a main string |
STRZERO() | Convert a numeric expression to a character string, zero padded. |
SUBSTR() | Returns a substring from a main string |
TRANSFORM() | Formats a value based on a specific picture template. |
TRIM() | Remove trailing spaces from a string. |
UPPER() | Converts a character expression to uppercase format |
VAL() | Convert a number from a character type to numeric |