On Fri, Dec 19, 2008 at 13:16, Drew Jensen <[email protected]>wrote:
> Rainer Schuetz wrote: > >> >> On 19.12.2008, at 17:48, John Toliver wrote: >> >> JT - I wasn't sure what other information to provide. But I'm running >>> Openoffice 3, Base. Using the standard HSQLDB for the backend. Using >>> GNU/Linux 2.6.24-21-generic. >>> >> >> So you might want to check online-documentation for HSQLDB (google it up, >> you might even try HSQLDB TRIM RTRIM) >> >> Oh give google a day off and try this: > > http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#String_Functions I went to the above site and have been trial and erroring with the rtrim command in the SQL command window. I get the following errors: I enter in this: RTRIM( ' . ' ) - I'm trying to tell it to remove all trailing spaces in any field after the last period. I receive this error: 1: Unexpected token: RTRIM in statement [rtrim] So what do I need to do to make sure this command is executing on the right table/query?
