/*This SQL script uses the Demo database.
  This sample illustrates use of POS function.
  The query retrieves events' names address of
  position of the word 'Finals' in it.*/

select Event_Name, Pos('Finals', Event_Name) from  events
