SQL spaces in field names

[Drstein99]

if there are spaces in the field names stored on the table, whats the proper way of calling it? normally I would:

 

SELECT FIRST NAME, LAST NAME FROM EMPLOYEES

 

but I'm getting errors I'm sure because of the spaces in the field names. Please help, thanks

[techmanbd]

try first_name last_name

 

but got to say that using spaces in the field names in not proper to do. it definetely should not be done. for the obvious reason

[Drstein99]

SELECT employee.[first name], employee.[last name], stats.sales, stats.refusals, stats.dns from stats,employee where stats.[employee number] = employee.[employee number]

 

This is the proper structure. I figured it out.

 

Yea I dont think underscore would work; simply because the program would have no way of knowing if the are underscores in the field name or spaces.

[Derek Stone]

I believe what techmanbd is trying to get at is the argument that your field names shouldn't contain spaces altogether.

[techmanbd]

Yes, that is what I mean

[DayWalker]

Yeah if you dont wanna use underscores try camel casing eg: firstName; lastName ect. Try stay clear from spaces will only cause more confusion in coding.

[Drstein99]

Thanks for the advice. Unfortunately, some things are out of my control. Often I'm assigned to make changes or alterations to existing code, setup in a certain fashion.

 

Had changing the field names been an option, I would have to change over the rest of the company's pre-existing programs that rely on those field names to be in that fashion: which is creating way more work then finding out how to deal with spaces in field names.