Menu
I added a field in SQL Server 2008 and it put the column name in brackets like this: [column2]. The other column names don't have brackets. What do the brackets mean?
The column is named macro-writer
Should I remove the minus sign and replace it with an underscore?
515
On SQL Server and MS Access, square brackets have a special meaning when used in a query filter. The square brackets are used to specify a set or range of characters, as in "[A-Z]" which would match any single character from 'A' to 'Z'.
Yes, the SQL standard allows parentheses.
1) If you have SQL keyword, space or any other illegal characters then you need to use square brackets.
Brackets are a form of quoting. It's only necessary if the column name contains spaces or punctuation or conflicts with a reserved word, but many wizards will just add the brackets for all field names to avoid the logic for deciding whether they are necessary.
187
Columns enclosed in square brackets are usually keywords or contain special characters or spaces.
What specific column name do you have enclosed in brackets?
36
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
