>I am loading in date from several years of free tables into one table. Over the past few years a field was changed from Char to a date. When I complete my load I would like to change that field to a date. So what is the command syntax that would allow me to change a field named pm416date from a character to a date in the table pminput?
>
>TIA

Look at the ALTER TABLE statement in the help

ALTER TABLE pminput ALTER COLUMN mychardate D