Hmm. In the Execute SQL Statement dialog, I had
UPDATE "Addresses" SET ADDR = TRIM ( ADDR )
Hi Barbara,
I believe it was Mr Reagan that said - 'Trust but verify."
Out of the box HSQL has
LTRIM = Left Trim
RTRIM = Right Trim
But no TRIM... if you could see how hard I am laughing right now
Anyway -UPDATE "Addresses" SET ADDR = LTRIM ( RTRIM( ADDR ) ) - does do
a full TRIM.
Again, the commands are in the Users Guide at http://hsqldb.org or a
quick list can found in this document.
http://www.paintedfrogceramics.com/OpenOffice/hsql_functions.ods
Sorry for the mistake.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]