sorry I assumed it wasn't working I didn't read your post.
[] is only for reserved names. i.e. SELECT, WHEN, WHERE, DELETE, DATE, MONTH, THEN, ELSE, END, etc.

I see, and I believe it also only used when column names have spaces in between them

From what I understand yes.

Oh ok, so I guess I get it now.

Thank you for your response finito! and most especially thank you to ketsuekaime! marking this as solved now! thanks again!

I see, and I believe it also only used when column names have spaces in between them

That is not good practice and should be avoided, same goes for named Variables.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.