The following table lists all of the SQL string operators and functions supported by EBX®, along with their standard SQL syntax. Some functions can have optional parameters: they are surrounded by square brackets.
| Operator syntax |
Description and example(s) |
| string |
|
| CHAR\_LENGTH(string) |
Returns the number of characters in a character string SELECT CHAR_LENGTH('Alfreds Futterkiste') : 19 |
| CHARACTER\_LENGTH(string) |
As CHAR\_LENGTH(string) SELECT CHARACTER_LENGTH('Alfreds Futterkiste') : 19 |
| UPPER(string) |
Returns a character string converted to upper case SELECT UPPER('SQL Tutorial is FUN!') : SQL TUTORIAL IS FUN! |
| POSITION(string1 IN string2 ) |
Returns the position of the first occurrence of string1 in string2 starting at a given point if specified SELECT POSITION('is fun' IN 'Tutorial is FUN!') : 0 SELECT POSITION('fun' IN 'Tutorial is FUN, very FUN!' FROM 17) : 0 |
| TRIM( { BOTH |
LEADING |
| OVERLAY(string1 PLACING string2 FROM integer ) |
Replaces a substring of string1 with string2 SELECT OVERLAY('Tutorial is very FUN!' PLACING 'VERY' FROM 13) : Tutorial is VERY FUN! SELECT OVERLAY('Tutorial is very FUN!' PLACING 'VERY' FROM 13 FOR 4) : Tutorial is VERY FUN! |
| SUBSTRING(string FROM integer ) |
Returns a substring of a character string starting at a given point SELECT SUBSTRING('Tutorial is very FUN!' FROM 13) : very FUN! SELECT SUBSTRING('Tutorial is very FUN!' FROM 13 FOR 4) : very |
