Parameter not giving value that it's attributed with

Question

hi there, i am currently having a (what some of you might consider a very simple) Problem which is really confusing me.

i am doing the following:

    DECLARE @Jan as nvarchar
    SET @Jan = '200 €'

and when i say:

select @Jan

the value i get is just : 2

how is this possible, and why am i not getting the exact value i am Setting for the Parameter?
thanks a lot in advance

Answer 1

thats because you've not specified length for nvarchar field as it assumes default value of 1

see

http://visakhm.blogspot.in/2010/02/importance-of-specifying-length-in.html

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

Answer 2

Thank you