Division by zero error handling

[David Lemire]

Hi people,

I need a little guidance here. To make a long story short, I have a string which would be "(123/0)+23". I need to put that string in a dynamic query. However, I want to avoid the division by zero error.

if charindex('/0',@DynamicNumber) <> 0

that won't work here, because I can have 0.002...

Is there a way to do the update query: update #output set Column = @DynamicNumber

and catch the error if I get a division by zero. In that case, I would just like to let the cell as a null value.

Thanks for your help

[Rune Bivrin]

set arithabort off
set arithignore on
set ansi_warnings off
select 17/0 as foo, 17/10 as bar

arithabort and ansi_warnings off turn off the error
arithignore on supressess the message

Rune

[David Lemire]

Thanks Rune!

That's exactly what I was looking for