You aren't interpreting the error message correctly, but that is besides the point...
Using your example, have you tried something like this: select field1, [a1].["stupid field name"] as easiertohandle from "piece of crap table" a1 i.e. wrap 'stupid field name' in double quotes (or maybe single quotes)... -- Matt Jarvis Eugene, Oregon USA _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAPT54rYqdDdkUF0n=z9TV5mp=1dsfnyjewlve-pkree5nyv...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.