0

I can't figure out which syntax to use for fields in my NexusDB that have spaces in them. I've tried the usual things like: [ ] `` but none of these work, the query just errors. So an example query might be:

select `offical name` from MyTable
select [official name] from MyTable

(these do not work)

Thanks,

Karl..

kstubs
  • 808
  • 4
  • 18

1 Answers1

1

The delimiter for delimited identifiers according to ISO 9075 (aka the SQL standard) is a double quote. Which is what NexusDB implementes:

select "official name" from MyTable
Thorsten Engler
  • 2,333
  • 12
  • 13
  • I'm not sure why I didn't try that one. Probably because I'm a SqlServer guy, and double quotes is something else. – kstubs Dec 17 '13 at 17:12