On 10/18/07, Kostis Mentzelos <mentzelos@xxxxxxx> wrote:
> Is there any other way to clear trailing spaces when I restore the table?
After you restore, you can do:
UPDATE V1
SET
NAME = TRIM(TRAILING ' ' FROM NAME)
, DATE = TRIM(TRAILING ' ' FROM DATE);
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
