Functions
String Functions
- CASE
- CHOOSE
- COMPARE
- CONCAT
- CONCATENATE
- DATESTR
- ENDSWITH
- FORMAT
- FROMBASE64
- INSTR
- JOIN
- JSELECTTOKEN
- LEFT
- LEN
- LENGTH
- LOWER
- LTRIM
- MD5HASH
- MID
- NEWLINE
- OBFUSCATE
- PADLEFT
- PADRIGHT
- PROPER
- PROPERTY
- REPLACE
- REPLACEREGEX
- RIGHT
- RTFTOPLAINTEXT
- RTRIM
- SEARCH
- SHA1HASH
- SPLIT
- STARTSWITH
- STR
- SUBSTR
- TOARRAYSTRING
- TOBASE64
- TOBYTEARRYASCII
- TOBYTEARRAYUNICODE
- TOBYTEARRAYUTF8
- TRIM
- UPPER
STR
Converts a value to a string. Failure to convert will result in a null string.
Syntax
string STR(object value)
Example
STR(123@abc.com)
Will return "123@abc.com".