FUNCTION | DEFINITION |
= , == , != , <> , <= , >= , < , > |
All common equality/inequality operators are applicable to strings and are applied in a case sensitive manner. In the following example x, y and z are of type string. (eg: not((x <= 'AbC') and ('1x2y3z' <> y)) or (z == x) ) |
in |
True only if ![]() ![]() x in y or 'abc' in 'abcdefgh' ) |
like |
True only if the string x matches the pattern y. Available wildcard characters are `*' and `?' denoting zero or more and zero or one matches respectively. (eg: x like y or 'abcdefgh' like 'a?d*h' ) |
ilike |
True only if the string x matches the pattern y in a case insensitive manner. Available wildcard characters are '*' and '?' denoting zero or more and zero or one matches respectively. (eg: x ilike y or 'a1B2c3D4e5F6g7H' ilike 'a?d*h' ) |
[r0:r1] |
The closed interval ![]()
![]() |
:= |
Assign the value of x to y. Where y is a mutable string or
string range and x is either a string or a string range. eg:
Note: For options 7 and 8 the shorter of the two ranges will denote the number characters that are to be copied. |
+ |
Concatenation of x and y. Where x and y are strings or
string ranges. eg
|
+= |
Append to x the value of y. Where x is a mutable string
and y is either a string or a string range. eg:
|
<=> |
Swap the values of x and y. Where x and y are mutable
strings. (eg: x <=> y ) |
[] |
The string size operator returns the size of the string
being actioned. eg:
|