SQL Newbie needs help on renaming fields

SQL Newbie needs help on renaming fields

Post by Rod » Sun, 31 Dec 1899 09:00:00



Please help.

I've never needed to use SQL before and it might as well be Russian.
But it appears I need to use it now in some fashion and I'm completely
clueless.

I need to rename a field in a table on the fly and can't seem to find
any other way to do it.  The type and lengh of the field won't change,
just the name.  Is there a way that SQL will do this without changing
the position of the renamed field in the table.

Thanks to all you Guru's for your help.