Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00) (30216-90269)
Chapter 10 175
Technical Articles
New Features in ALLBASE/SQL Version G3
Syntax . [ LOWER (stringexpr)]
Upper
Converts all the characters in stringexpr to upper case
Syntax . [ UPPER (stringexpr)]
Position
Searches for the presence of the string stringexpr1 in the string
stringexpr2 and returns a numeric value that indicates the position at
which stringexpr1 is found in stringexpr2
Syntax . [ POSITION (stringexpr1, stringexpr2)]
Instr
Searches char1 beginning with its nth character for the mth occurrence
of char2 and returns the position of the character in char1 that is the
first character of this occurrence. If n is negative, Instr counts and
searches backward from the end of char1. The value of m must be
positive. The default values of both n and m are 1, meaning Instr begins
searching at the first character of char1 for the first occurrence of char2.
The return value is relative to the beginning of char1 regardless of the
value of n, and is expressed in characters. If the search is unsuccessful
(if char2 does not appear m times after the nth character of char1) the
return value is 0.
If n and m are not specified the function is equivalent to the ANSI
SQL-92 POSITION function, except that the syntax is slightly
different.
Syntax . [ INSTR (char1, char2 [,n [,m]])]
Ltrim
LTRIM function trims the characters specified in charset from the
beginning of the string stringexpr.
Syntax . [ LTRIM (charset, stringexpr)]
Rtrim
RTRIM function trims the characters specified in charset from the end of
the string stringexpr.
Syntax . [ RTRIM (charset, stringexpr)]
Trim
TRIM function allows you to strip the characters specified in charset
from the beginning and/or the end of the string stringexpr. If charset is
not specified, then blank characters would be stripped from stringexpr.