Why sql convert number to '*' charachter

Question

I run this query in SQL Server 2008

declare @a varchar(1) select @a = 22 select @a 

he returns it

 * 

why does this query do this result?

Answer 1

You will convert 2 characters to a field with 1 character.

He does not fit.

SQL indicates that data is missing. Otherwise, it only displays 2 , and you do not know if it was the full value or not.

Answer 2

insufficient space was found -

 declare @a varchar(2) select @a = 242 select @a 

it will also do it

Answer 3

Use the following code:

  declare @a varchar (2)
 select @a = 22
 select @a