| Concat | Returns concatenated string. | String | String 1, String 2 |
| CHAR2HEXINT | Returns the hexadecimal representation for a character string. | | String expression |
| Index | Returns the starting position of string 2 inside string 1. Returns 0 if string 2 is not found. | String | String, Search string |
| Soundex | Returns a character string that represents the Soundex code for a string_expression. | String | String expression |
| Substring | Returns the substring of the string provided. | String | String, start position, length |
| Trim | Trims blanks from a given string. | String | Leading/Trailing/Both String to trim |
| VARGRAPHIC | Returns the VARGRAPHIC representation of the character data in a character_string_expression. | String | String expression |