definition of QuotePrefix Quotesuffix

Sometimes database tables have names, or contain columns with names, which contain spaces or other characters which have a special meaning in the version of SQL used by that database.

To ensure that these names are interpreted correctly, they have to be enclosed within a pair of special characters which are know as the QuotePrefix and QuoteSuffix characters. For example the square bracket characters '[' and ']' are commonly used for this purpose.

So, for example, if you have a column called first name, then you'd refer to it as [first name] in a query to make it clear that first name is one identifier and not two.

Similar considerations apply to other database objects which have names containing spaces etc. such as indexes or views.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes11y ago
Sometimes database tables have names, or contain columns with names, which contain spaces or other characters which have a special meaning in the version of SQL used by that database.

To ensure that these names are interpreted correctly, they have to be enclosed within a pair of special characters which are know as the QuotePrefix and QuoteSuffix characters. For example the square bracket characters '[' and ']' are commonly used for this purpose.

So, for example, if you have a column called first name, then you'd refer to it as [first name] in a query to make it clear that first name is one identifier and not two.

Similar considerations apply to other database objects which have names containing spaces etc. such as indexes or views.