SQL Unexpected return value

[stoymigo]

I created a sql-scalar function, but you can copy&paste the code below because it does the same:

Declare @Varchie as Varchar
Set @Varchie = '51'
Select @Varchie

This returns 5, why not 51?

Thx

 

[stoymigo]

Ok, someone told me that Varchar is same as Varchar(1), so I made it Varchar(50) and it works.

 

[dabean]

You need to set the size of the variable.

Declare @Varchie as Varchar(2)
Set @Varchie = '51'
Select @Varchie

Edit: Glad you're sorted.