ALTER TABLE info_billoflading CHANGE COLUMN i_billoflading_dockReceipt i_billoflading_dockReceipt VARCHAR ( 12 ); (this worked) Thanks. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130904/c024e78e/attachment.html>