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
We made three requests of the technical support personnel and despite the fact that these were all implementation questions (not bugs in their software) we received support within 24 hours. It is rare to get such good customer support these days and I really appreciate everything ComponentAce has done for us.