Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
Are you taking about the data in the field1..?
What is the datatype of field1. Is that CHAR(03)...? Do you need to change that to CHAR(04) ...?
If you want to change it from CHAR(03) to CHAR(04) then get in touch with DBA and make sure all the application programs accessing that table/column are changed accordingly.The DDL of that table needs to be altered. If you are talking about just the data then it could be done with simple SQL query.