Can I define field names with more words in Access and SQL Server like
field: "Bus station" instead "BusStation" or "Bus_Station"? I have had
problems because of this in VB6. Can I have problems in VB 2005 or C# 2005
and SQL Server?

Goran ((E-Mail Removed)) writes:
> Can I define field names with more words in Access and SQL Server like
> field: "Bus station" instead "BusStation" or "Bus_Station"? I have had
> problems because of this in VB6. Can I have problems in VB 2005 or C# 2005
> and SQL Server?

Yes you can. You need to enclose the name in brackets [] or double quotes ""
whenever you use it.


--
Erland Sommarskog, SQL Server MVP, (E-Mail Removed)

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hi,

It's not recommended though.

You shouldn't use the field names as captions if you want something more
readable. For instance, if you're using a DataSet you can assign the
Caption property to something other than the field name. In grids you can
easily set the headers at design-time.

--
Dave Sexton

"Goran" <(E-Mail Removed)> wrote in message
news:emat1f$90e$(E-Mail Removed)...
> Can I define field names with more words in Access and SQL Server like
> field: "Bus station" instead "BusStation" or "Bus_Station"? I have had
> problems because of this in VB6. Can I have problems in VB 2005 or C# 2005
> and SQL Server?
>