NVARCHAR

[Ringers]

Hi I trying to do a select query where a NVARCHAR column is equal to a 9 digit number, but it is returning an error.

Error:

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

Table:Bulkpay_OperatorAccounts

Columns:
User Id (nvarchar(16),null),
Contra Account BSB (nvarchar(6),null),
Contra Account Number(nvarchar(20),null),
Access Given (Bit, not null),
Signature (nvarchar(8),null),

Query:

SELECT *
FROM Bulkpay_OperatorAccounts
WHERE Contra Account Number = '012003-837391956'

Any help would be great, thanks.

 

[bborissov]

You should round every column or table name that have spaces in it or some keywords are used with square brackets:

SELECT *
FROM Bulkpay_OperatorAccounts
WHERE [Contra Account Number] = N'012003-837391956'

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[Ringers]

ah wow never seen that before, thanks.

 

[SQLSister]

It is best to never design tables with spaces, non-alpahnumeric characters (except _) or database keywords. This willl save a lot of debugging for issues like this.

"NOTHING is more important in a database than integrity." ESquared