VarChar Problem

[acko bogicevic]

Hi
I have the folowing stored proc.

CREATE PROC NewDoc
@Vrsta nvarchar(3),
@Sifra int OUTPUT
AS

INSERT Doc(Vrsta)
VALUES ( @Vrsta)

SELECT @Sifra = @@IDENTITY

declare @sifra int
exec novidokument '06', @sifra output
print @sifra

The field Vrsta in table Doc is varchar(3), but after insert into the
table the value in the table is not 06 then 6. The same thing is with
everty string containing zero on the begining.
How can i resolve this problem?
Thanks
Alex

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!