I am trying to run the following query on a Progress database.
However it gives me an error. I think it is because of the # in the column name.
I have tried the following code which I know works if there is an illegal character in the name like a space but it doesn't work either.
SELECT [item#] as itemnumber
I do not have the luxury of renaming the fields in the table so I need to figure out how to structure the query with that column name.
thanks for your help.