query tool in 2k enterprise manager

[mikej28621]

While creating a query with the query tool in Microsoft SQL Server 2k enterprise manager. It always replaces my criteria ='RE' with =N'RE'. It also changes it in the full query statement.

SELECT *, STATUS AS Expr1
FROM Customer
WHERE (STATUS = N'RE')

It apears to run normally but is not like any syntax I have seen before. Is this a bug or normal.

Thanks in advance.

 

[Sudmill]

Dont worry, SQL Server is using prefixing to ensure that it is appearing as a Uncode string. This should not have any effect on your query.

See :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;239530

What character set is your server set up with btw?


Cheers

John (Sudmill)