>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
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers