select isnull ( convert (char(3),1.0/9) ,'*')
-- or

select isnull ( convert (char(3),1/9.0) ,'*')

Msg 8115, Level 16, State 5, Line 1
Arithmetic overflow error converting numeric to data type varchar.

Select select isnull ( convert (char(8),1.0/9) ,'*')

demonfox (3/14/2013)

---

cheeky ...

didn't occur a doubt on the 0
though I had a doubt over

select isnull ( convert (char(3),1.0/9) ,'*')
-- or

select isnull ( convert (char(3),1/9.0) ,'*')

and it clears out as it does throws an error

thanks for the explanation

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 :D

Nice question , though ...

Thanks for the question ..

Danny Ocean (3/15/2013)

---

Really a nice and good question.

one more thing apart from this question. if you set ARITHABORT OFF and then execute below code, it will give output as "*" due to insufficient char length. and if you set char length more than 7, it will give "0.111111".

It denotes that we need to provide an insufficient length whenever we convert values in char or varchar.


SET ARITHABORT OFF
select isnull ( convert (char(3),1.0/9) ,'*')

Danny Ocean (3/15/2013)

---

Really a nice and good question.

one more thing apart from this question. if you set ARITHABORT OFF and then execute below code, it will give output as "*" due to insufficient char length. and if you set char length more than 7, it will give "0.111111".

It denotes that we need to provide an insufficient length whenever we convert values in char or varchar.


SET ARITHABORT OFF
select isnull ( convert (char(3),1.0/9) ,'*')