SQL 101 - can you have spaces in a field name?

[pixelbro]

Sorry for the simple beginner's question. I've never used spaces in field names, always use either dot (.) or underscore (_) to link two words together, eg, last_name or last.name.

Just received a client's access database that has field names with spaces: "last name", "first name", etc.

Can I work with these fields using ASP to query the database?

thanks,

pixelbro

 

[AccessMoron]

Yes, to call the field put it into []

so First Name should be written as [First Name]

Also, it is bad practice to use the . to split up database field names, this is because the . means something completly diffrent in other languages sucah as VB

 

[pixelbro]

Thanks for your answer and for the tip about the dot operator.