>>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
That did it, thanks.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope