Hello,

Can anyone tell me how to make this alter table command work?

alter table tblprospects rename column telephone number to phone

I've tried square brackets, parenthesis, single, and double quotes around
telephone number and they all error out.

Thanks, Mike

RENAME is not a valid argument with this statement (as far as I know) ...
you would have to add a new column, run an update to copy the data from
oldcolumn to newcolumn, then drop the old column.

--
Scott McDaniel
CS Computer Software
www.thedatabaseplace.net

"mharness" <mike_harness (AT) hotmail (DOT) com> wrote