CODEWITHSUNDEEP
sqladonexusdb
kstubs
kstubs

Reputation: 808

NexusDB Field with spaces ADO SQL

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..

Upvotes: 0

Views: 184

Answers (1)

Thorsten Engler
Thorsten Engler

Reputation: 2361

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

Upvotes: 1

Related Questions