/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample illustrates use of SUBSTRING function.
  The query retrieves events" names where first letter is excluded as well as letters after tenth.*/

select (substring(e1."Event_Name", 2, 9)) as "SubEventName"
  from "events" e1
