MS-SQL Server 2000 Not able to select data from tables and views containing colons in their names -

[Günther]

 Posted by:  Günther 

MS SQL Server 2000 / 2005 do allow special characters in names for tables
and views
If a table or view contains a colon, it is not possible to make a SQL select
from a TD application
Receiving runtime error due to the fact TD runtime might mistaking interpret
the colon as a prefix for a bind-var

Example:

Select * from southwind.dbo.[my weird view] - working with TD

Select * from southwind.dbo.[my weird colon : view] - not working with TD