"Juan Riera" <juanriera@hotmail.com> wrote in message news:<a050ee$9bi$1@news.tht.net>...
> It works - thanks, Lee
> However I don't understand what happened as I have created this table
> through W98/ODBC from Approach and I did not put explicitly any quotes on
> variables. Maybe Approach does it? Can I eliminate this quotes from column
> names and put names in small caps?
Well, if you're not constantly recreating the table, why not rename the columns?
Something like:
Alter table previs rename "CDART" to cdart;
Calvin