Thanks Nancy
The problem was I was trying to rename the field to a numeric name.
Thanks again.
>>Hello all.
>>I can't get the following code to work.
>>
>>ALTER TABLE (lcFile) RENAME COLUMN (lcField1) TO (lcField2)
>>
>>
>>ALTER TABLE (lcFile) RENAME COLUMN ('A') TO ('MyField') works, but the above code does not.
>>
>
>What are the
real values of the variables lcFile, lcField1, and lcField2?
Work as if you don't need money
Love as if you've never been hurt before
Live as if this is your last day to live
Dance as if no one's watching