syntax question

[Alex]

example from script of job
....
SELECT @JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'Start new error log file at Midnight&#39


Would you please explain me why MS use
WHERE (name = N'Start new error log file at Midnight&#39
and not
WHERE (name = 'Start new error log file at Midnight&#39

what is use of N

Thanks

[CrankyDBA]

The leading uppercase N creates a Unicode string.


------------
Alex at 6/13/01 8:44:30 AM

example from script of job
....
SELECT @JobID = job_id
FROM msdb.dbo.sysjobs
WHERE (name = N'Start new error log file at Midnight&#39


Would you please explain me why MS use
WHERE (name = N'Start new error log file at Midnight&#39
and not
WHERE (name = 'Start new error log file at Midnight&#39

what is use of N

Thanks