#2 "where" in update sentence

[Anonymous]

Hi, when i try to update a record in a table i get an "N"
extra for each varchar field in the "where" part of the
sentence, for example :

exec sp_executesql @stmt = N'UPDATE [STMPDE]
SET [STMPDE_DESCRP] = N''FLETE A
POSADAS'' , [STMPDE_FECMOD] = CONVERT
(DATETIME,''2005-04-20 00:00:00:000'',121)
WHERE [STMPDE_TIPPRO] = N''02N''
AND [STMPDE_ARTCOD] = N''1220N''

IF @@ERROR <> 0 BEGIN
RETURN
END
'

the condition should be :

WHERE [STMPDE_TIPPRO] = N''02''
AND [STMPDE_ARTCOD] = N''1220''

i mean, without the "N" at the end.

Why is that ?

Thanks.

Martin.