how to produce 0 without using any number in sql server ?

1.
select $
2.
select £
3.
Declare @num int
Set @num = ''
Select @num

this is more useful. see what happens when a set an integer to null

Note that the following does NOT produce 0, it will produce NULL

Declare
Select @num int @num