didn't occur a doubt on the 0 :-P
though I had a doubt over
select isnull ( convert (char(3),1.0/9) ,'*')
select isnull ( convert (char(3),1/9.0) ,'*')
and it clears out as it does throws an error
Msg 8115, Level 16, State 5, Line 1
Arithmetic overflow error converting numeric to data type varchar.
When Implicit conversion occurs , it gives out the output with default precision of 18,6..
so 1.0/9 is 0.111111..
Select select isnull ( convert (char(8),1.0/9) ,'*')
anything less than 8 would have the arithmetic overflow error for this scenario
Nice question , though ...
Thanks for the question ..
Wondering what I would do next , when I am done with this one