| Operator/Function | Description | Operand Types | Result Type | |
|---|---|---|---|---|
| First | Second | |||
| ASCII | Convert character to ASCII code | C |
|
N |
| CHR or CHAR | Convert ASCII code to character | N |
|
C |
| CONCAT | Join character fields | C | C | C |
| HEAD | Leading characters | C | N | C |
| IN | One string in another? | C | C | Y |
| NUMTOCHAR | Convert number to characters | N | - | C |
| POS | Position in character field | C | C | N |
| TAIL | Trailing characters | C | N | C |
| UPPERCASE | Convert to upper case | C |
|
C |
| VALIDNUMBER | Only numbers in string? | C |
|
Y |