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!?