Strings


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