function_trim.sql

来自「AbsDataBase5.16 最新版」· SQL 代码 · 共 8 行

/*This SQL script uses Demos.abs database. 
  Please open ...\AbsoluteDatabase\Demos\Data\Demos.abs database file.
  This sample illustrates use of TRIM function.
  The query retrieves events" names. Although some blanks are appended on both sides of column "Event_Name", function trim removes them. Use LTRIM or RTRIM if you want to remove blanks from on side only.*/

select (trim(" " + e1."Event_Name" + " ")) as "TrimEventName"
  from "events" e1