Field identifier character

S Hovens

New Member
Hi all,

I've got a problem with a query in Progress 9.1E SQL Explorer Tool. I want to extract some data from a third party application that we use in our company. The problem is that one of the fields I need to extract has a minus character '-' within the fieldname, for example 'max-amount'.

In MS SQL I can select this field by putting the fieldname between the characters '[]', thus '[max-amount]'.

Is there a simular character in progress that I can use the select the field in a query?

Thanks!
 
Put double quotes around the field.

e.g. select "dash-field" from pub."table-with-dash";

casper.
 
Back
Top