Strings & Characters Functions
| ASC | Returns the ASCII / ANSI number for the first character in a text string (Integer). | 
| ASCW | Returns the Unicode number for the first character in a text string (Integer) | 
| CHR | Returns the character with the corresponding ASCII / ANSI number (Variant / String). | 
| CHRW | Returns the character with the corresponding Unicode number (Variant / 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 (Variant / String). | 
| INSTR | Returns the position of a substring within a larger string (Variant / 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 (Variant / String). | 
| LEFT | Returns a substring from the left of a string (Variant / 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 (Variant / String). | 
| MID - Function | Returns a substring from the middle, left or right of a string (Variant / 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 string (Variant / String). | 
| RSET | Right aligns a string within a string variable. | 
| RTRIM | Returns the text string without trailing spaces (Variant / String). | 
| SPACE | Returns the specified number of spaces (Variant / String). | 
| STR | Returns the text string of a number (Variant / String). | 
| STRCOMP | Returns the result of a string comparison (Variant / Integer). | 
| STRCONV | Returns the text string converted to a specific case or type (Variant / String). | 
| STRING | Returns a repeating character of a given length (Variant / String). | 
| STRREVERSE | Returns the text string with the characters reversed (Variant / String). | 
| TRIM | Returns the text string without leading and trailing spaces (Variant / String). | 
| UCASE | Returns the text string with all the characters converted to uppercase (Variant / String). | 
| VAL | Returns the first number contained in a string (Double). | 
| ASC Returns the ASCII / ANSI number for the first character in a text string (Integer).  | 
| ASCW Returns the Unicode number for the first character in a text string (Integer)  | 
| CHR Returns the character with the corresponding ASCII / ANSI number (Variant / String).  | 
| CHRW Returns the character with the corresponding Unicode number (Variant / 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 (Variant / String).  | 
| INSTR Returns the position of a substring within a larger string (Variant / 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 (Variant / String).  | 
| LEFT Returns a substring from the left of a string (Variant / 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 (Variant / String).  | 
| MID - Function Returns a substring from the middle, left or right of a string (Variant / 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 string (Variant / String).  | 
| RSET Right aligns a string within a string variable.  | 
| RTRIM Returns the text string without trailing spaces (Variant / String).  | 
| SPACE Returns the specified number of spaces (Variant / String).  | 
| STR Returns the text string of a number (Variant / String).  | 
| STRCOMP Returns the result of a string comparison (Variant / Integer).  | 
| STRCONV Returns the text string converted to a specific case or type (Variant / String).  | 
| STRING Returns a repeating character of a given length (Variant / String).  | 
| STRREVERSE Returns the text string with the characters reversed (Variant / String).  | 
| TRIM Returns the text string without leading and trailing spaces (Variant / String).  | 
| UCASE Returns the text string with all the characters converted to uppercase (Variant / String).  | 
| VAL Returns the first number contained in a string (Double).  | 
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top