Home Forums SQL Server 2008 SQL Server 2008 - General Fixing Divide by Zero Error RE: Fixing Divide by Zero Error

  • April 15, 2013 at 11:06 pm

    #1606679

    VegasL (4/15/2013)

    Hello,

    I have in select statement select t1.A/t1.B but get divide by zero error

    when I used with isnull isnull(t1.A/t1.B,'-')

    I get error Error converting data type varchar to float.

    how to fix?

    Thanks

    select t1.A / nullif(t1.B,0)