andrew wrote:
Well, I didn't mean to get into a preaching mode there, and am afraid
I somewhat did.
Oops -- ignore my last message, just looked at yours again and saw
Say you have a table named t1 and a column c1 the column contains
records with erroneous leading or trailing spaces, now you want to clean
that up.
Open the SQL window. Tools > SQL
Enter this SQL command:
UPDATE "t1" SET "c1" = TRIM( "c1 )
I'll try that!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]