Welcome!

[silvercover]

Hi,

I need to select some rows from my MSSQL database where some of my field names have [ and ] chars in their names. so when I want to post my query SQL Server says this:

An expression of non-boolean type specified in a context where a condition is expected, near 'Passwd'.

Here is my SQL query:

Code: Select all

SELECT [TAC_ID]
      ,[TAC_Attr]
      ,[TAC_Val]
  FROM [NTTabDB].[dbo].[TAC_USR]
  WHERE [Global]Passwd =  53505;


What's wrong?
Thanks in advance.

[centered-effect]

This is a just a guess, but wouldn't [Global]Passwd be [Global].Passwd (note the period). If not, what is the table/column name? That should help you there. table.columnName