tical

mysql will prob error if you try to change the field to 9 chrs... back up before trying this, but it should work (and do it to the whole table)


update table set field = substring(field, 1, 9)

__________________
112.020.756