Spaces in column names, won't work with my select statements.

I have a db auto uploaded to me everyday. I am displaying information from the db, but some of the columns contain spaces. When I use a space in a select statement it obviously does not work. Is there some special syntax I need to allow for a column name that contains a space?

Well tell these people to **STOP** putting SPACES in their field names.

That will fix you problem, for ever!

Anyway...try putting the field name between [ and ]
for example:

SELECT [Field 1] FROM table....

Hope this helps!
Sincerely

Vlince

Yes I agree, the best method would be no spaces. I mentioned it to the database guy and he about had a heartattack. His response was "that isn't as easy as it sounds".

Thanks for the solution, works beautifully!

Has anyone else noticed, its the people who dont know anything about databases who want the most output from them? ;-)

That's really messed up.....[] should be used in anycase though....