Whats the N for 1

[cglaves]

In a query like:

select * from dbo.sysobjects where id = object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1

what the heck is the N before the string '[dbo].[Users]'?

 

[earthandfire]

I believe the N prefix indicates Unicode (i.e) 2 bytes for each character instead of the normal one.


Hope this helps.

 

[chiph]

earthandfire is correct. You should use it whenever the column you're comparing with is of type NCHAR, NVARCHAR, or NTEXT.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first