Strings & Characters Functions

ASCReturns the ANSI number for the first character in a text string (Integer).
CHRReturns the character with the corresponding ANSI number (String).
CSTRReturns the expression converted to a string data type (String).
FORMATReturns the text string of a number or date in a particular format (String).
INSTRReturns the position of a substring within a larger string (Long).
INSTRREVReturns the position of a substring within a larger string, starting at the end (Long).
LCASEReturns the text string with all characters converted to lowercase (String).
LEFTReturns a number of characters from the left of a string (String).
LENReturns the number of characters in a string (Long).
LSETLeft aligns a string within a string variable.
LTRIMReturns the text string without leading spaces (String).
MID - FunctionReturns the text string which is a substring of a larger string (String).
MID - StatementReplaces a specified number of characters with characters from another string.
REPLACEReturns the text string with a number of characters replaced (String).
RIGHTReturns a number of characters from the right of a string (String).
RSETRight aligns a string within a string variable.
RTRIMReturns the text string without trailing spaces (String).
SPACEReturns the specified number of spaces (String).
STRReturns the text string of a number (String).
STRCOMPReturns the result of a string comparison (Integer).
STRCONVReturns the text string converted to a specific case or type (String).
STRINGReturns a repeating character of a given length (String).
STRREVERSEReturns the text string with the characters reversed (String).
TRIMReturns the text string removing leading and trailing spaces (String).
UCASEReturns the text string with all the characters converted to uppercase (String).
VALReturns 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 data type (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, starting at the end (Long).
LCASE
Returns the text string with all characters converted to lowercase (String).
LEFT
Returns a number of characters from the left of a string (String).
LEN
Returns the number of characters in a string (Long).
LSET
Left aligns a string within a string variable.
LTRIM
Returns the text string without leading spaces (String).
MID - Function
Returns the text string which is a substring of a larger 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 number of characters from the right of a 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).
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).

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top