String & Character Functions

ASC	Returns the ANSI number for the first character in a text string (Integer).
CHR	Returns the character with the corresponding ANSI number (String).
CSTR	Returns the expression converted to a string datatype (String).
FORMAT	Returns the text string of a number or date in a particular format (String).
INSTR	Returns the position of a substring within a larger string (Long).
INSTRREV	Returns the position of a substring within a larger string, from the end (Long).
JOIN	Returns a text string containing all the elements in an array (String).
LCASE	Returns the text string with all characters converted to lowercase (String).
LEFT	Returns a substring from the left of a string (String).
LEN	Returns the number of characters in a string (Long).
LIKE	This is a pattern matching operator.
LSET	Left justifies a string within a destination and fills the remainder with spaces.
LTRIM	Returns the text string without leading spaces (String).
MID - Function	Returns a substring from the middle, left or right of a string (String).
MID - Statement	Replaces a specified number of characters with characters from another string.
REPLACE	Returns the text string with a number of characters replaced (String).
RIGHT	Returns a substring from the right of a text string (String).
RSET	Right aligns a string within a string variable.
RTRIM	Returns the text string without trailing spaces (String).
SPACE	Returns the specified number of spaces (String).
SPLIT	Returns an array containing a specified number of substrings (Variant).
STR	Returns the text string of a number (String).
STRCOMP	Returns the result of a string comparison (Integer).
STRCONV	Returns the text string converted to a specific case or type (String).
STRING	Returns a repeating character of a given length (String).
STRREVERSE	Returns the text string with the characters reversed (String).
TRIM	Returns the text string removing leading and trailing spaces (String).
UCASE	Returns the text string with all the characters converted to uppercase (String).
VAL	Returns the numbers contained in a string as a numeric value of the appropriate data type (Double).

ASC Returns the ANSI number for the first character in a text string (Integer).
CHR Returns the character with the corresponding ANSI number (String).
CSTR Returns the expression converted to a string datatype (String).
FORMAT Returns the text string of a number or date in a particular format (String).
INSTR Returns the position of a substring within a larger string (Long).
INSTRREV Returns the position of a substring within a larger string, from the end (Long).
JOIN Returns a text string containing all the elements in an array (String).
LCASE Returns the text string with all characters converted to lowercase (String).
LEFT Returns a substring from the left of a string (String).
LEN Returns the number of characters in a string (Long).
LIKE This is a pattern matching operator.
LSET Left justifies a string within a destination and fills the remainder with spaces.
LTRIM Returns the text string without leading spaces (String).
MID - Function Returns a substring from the middle, left or right of a string (String).
MID - Statement Replaces a specified number of characters with characters from another string.
REPLACE Returns the text string with a number of characters replaced (String).
RIGHT Returns a substring from the right of a text string (String).
RSET Right aligns a string within a string variable.
RTRIM Returns the text string without trailing spaces (String).
SPACE Returns the specified number of spaces (String).
SPLIT Returns an array containing a specified number of substrings (Variant).
STR Returns the text string of a number (String).
STRCOMP Returns the result of a string comparison (Integer).
STRCONV Returns the text string converted to a specific case or type (String).
STRING Returns a repeating character of a given length (String).
STRREVERSE Returns the text string with the characters reversed (String).
TRIM Returns the text string removing leading and trailing spaces (String).
UCASE Returns the text string with all the characters converted to uppercase (String).
VAL Returns the numbers contained in a string as a numeric value of the appropriate data type (Double).