function_pos.sql

AbsDataBase5.16 最新版

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample illustrates use of POS function.
  The query retrieves events" names address of position of the word "Finals" in it.*/

select e1."Event_Name", (pos("Finals", e1."Event_Name")) as "PosFinals"
  from "events" e1