Novice Question about N' in a T-SQL 1

[redshadow]

Hi to all,

I just want to clarify myself what is N' used for?

Let's say:

if exists (select * from sysobjects where id = object_id(N'[dbo].[objName]')

I browsed all topics on SQL Server and I couldn't find any explanation about the purpose of N'.

Thanks in advance for the enlightenment.

 

[SonOfEmidec1100]

This is used to indicate a UNICODE string value. For more info search BOL for 'Using Unicode Data'

 

[redshadow]

Thanks.