Update question

[cleggfr]

Hi,

I've got a table t1 with a column TEST thats a varchar2(16). It holds a loads of records padded records, i.e they're all length 16 even though some entries are only 4 characters long. I need to update the column TEST to remove the padding but am struggling to come up with the SQL. Can anyone help please!?

[DaPi]

UPDATE T1 SET TEST=TRIM(TEST);

[cleggfr]

D'oh!! And there was me messing with self joins and stuff! Not having a good day :confused: