Frank Schönheit - Sun Microsystems Germany wrote:
So, the complete syntax if you want to use TRIM is
UPDATE "Addresses" SET ADDR = TRIM ( BOTH FROM ADDR )
where you can even omit the BOTH.
Ciao
Frank
Almost. TRIM( FROM <COLUMN> ) works in SQL View, but not in Designer View.
It generates a warning that the column is not found. and will not
execute the query.
Entered Issue 80128
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
