Search function: POSITION

The POSITION function takes two arguments: a substring and a search string. The POSITION function returns the position of the substring in the search string as an integer or as 0 if the substring is not found. If the substring is the empty string, the POSITION function returns 1. The POSITION function is case-sensitive:

Integer POSITION( substring Varchar, searchstring Varchar )

Example

The following code:

SELECT CUSTOMERS.CUSTID, CUSTOMERS.CUSTOMNAME

FROM "../Data Sources/MyDatabase/CUSTOMERS.SMA" CUSTOMERS

WHERE POSITION('Inc.', CUSTOMERS.CUSTOMNAME) > 0

returns:

106,Technical MicroSystems Inc.

111,Advanced Design Inc.

113,Technical Design Inc.

…

Copyright Actuate Corporation 2012