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