Communicator e3000 MPE/iX Release 6.0 Express 1 (C.60.01) (30216-90286)

Chapter 3 63
Technical Articles
ALLBASE/SQL Version G3 Article Update
ALLBASE/SQL Version G3 Article Update
by Doug Myers
Database Lab, Commercial System Division
Correction to Previously Published Article
The complete article showing new features in ALLBASE/SQL Version G3 was published in
the Communicator for Release 6.0. The following sections show correct syntax to replace
that from the original article. In the syntax and example below, the comma is replaced by
the word ‘IN’.
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 IN stringexpr2 )]
Example 2
SELECT POSITION ('world' IN 'hello world')
FROM SYSTEM.TABLE
WHERE NAME = UPPER('vendors');
Returns the numeric value 7.