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
COMPARE
Compares the values of two strings.
Syntax
bool COMPARE(string a, string b)
bool COMPARE(string a, string b, bool ignoreCase)
Example
COMPARE(ProductName,ProductSold)
If the ProductName is the same as the ProductSold then the function will return true, if they are not the same then false will be returned.