ALLBASE/SQL Version G3 Article Update

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

Example 2

 SELECT POSITION ('world' IN 'hello world')
 FROM SYSTEM.TABLE
 WHERE NAME = UPPER('vendors');

Returns the numeric value 7.