View Full Version : difference between [field] and field


zhuanyi
04-26-2007, 08:34 AM
Hello,
I understand that in an SQL string, you could either use [fieldName] or fieldName to search for an field in select statement, may I know what are the difference between the 2? Thanks!

Anyi

pbaldy
04-26-2007, 08:44 AM
The brackets are required when there are spaces or illegal symbols in the field name. Otherwise they're optional.