Using AS in sql queries

This question was asked here before, but it didn't

get a satisfactory answer (in my case).

We're using coldfusion as a frontend to an existing

progress 8.3b database. We set up an odbc link

using openlink. The problem is with dashes

in the field names. Coldfusion can't handle them.

We have a LOT of dashes, and a HUGE existing

codebase, so renaming all the fields with a

dash isn't really an option. The simple answer

would be to do queries like:

SELECT field-name AS fieldname from table

but progress doesn't accept this.

Is there a workaround for this problem?

greetings

Barteld