Originally Posted by
gandolf989
. . . . However, my guess is that the tables and column
names do have spaces, hence the OP needs to use double quotes.
Yes, I myself had to deal with developers using Ms Access to create tables which ended having embedded blanks and mixed case in the table/column names.
On the other hand, the OP states that "we are using a web based reporting system that has tools for building reports". Many of these reporting tools have dictionaries that will allow users to give a more descriptive name to tables, views and even columns. which is the possibility I tried to address.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Reply With Quote
