/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample illustrates use of LOWER function.
  The query retrieves events" names in normal capitalization and with all letters in lower case.*/

select e1."Event_Name", (lower(e1."Event_Name")) as "LoEventName"
  from "events" e1
