Does SQL allow underscores in the column name?

snips86x · 2 Feb 2015 at 18:36

As above really!

I've got a table which I'm trying to insert a column into and while the column is adding just fine, any scripts I run which reference that column fail which tells me the answer is no!

kitkat9933 · 2 Feb 2015 at 19:35

Perfectly fine.

planty · 2 Feb 2015 at 21:30

Yep should be fine. What error are you getting?

GravyMonster · 3 Feb 2015 at 11:12

What flavour of SQL - MSSQL, MySQL, others? It should be fine but if it's an obscure one there may be issues.

Also what's the query exactly?

snips86x · 3 Feb 2015 at 11:16

Thanks for your help!

I'm a bit of an SQL noob but managed to answer my own question. After hours of testing various combinations, it would appear the software is as fault.