> The name of the table in the context of your query is just a regular
> string, so the query should be:
>
> WHERE [name] = 'l0382_project1'
>
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "Mich" <no@mail.vb> wrote in message
> news:uOe%23Gl33HHA.5796@TK2MSFTNGP05.phx.gbl...
>> Hi,
>>
>> the table 'l0382_project1' exists in sql server. I can see it.
>> Now in asp.net, i want to check whether it exists but i get "invalid
>> column name":
>>
>> 1st attempt:
>> comd.CommandText = "SELECT COUNT(*) FROM sys.tables WHERE [name] =
>> [l0382_project1]"
>> connection.Open()
>> nr = comd.ExecuteScalar()
>>
>> Invalid column name 'l0382_project1'.
>>
>>
>> 2nd attempt:
>> comd.CommandText = "SELECT COUNT(*) FROM sys.tables WHERE [name] =
>> ['l0382_project1']"
>> connection.Open()
>> nr = comd.ExecuteScalar()
>>
>> Invalid column name 'l0382_project1'.
>>
>>
>> Could somebody tell me the right syntax, please?
>> Thanks
>> Mich