Found this in a code sample

• Kurt Kracaw

  Ten Centuries

  Points: 1166

  More actions

  February 1, 2006 at 8:07 am

  #168048

  Could someone tell what this does/how it works. It was in the select statement

  convert(numeric(10,2), convert(numeric(10,2), IsNull(Run, 0))

  I can figure out part of it but the convert(numeric(10,2), listed 2 times is confusing

  Kurt Kracaw

• allen davidson

  SSCertifiable

  Points: 7042

  More actions

  February 1, 2006 at 9:42 am

  #618147

  I'll bite.

  I think that one of the convets is redundant. Also I think it's missing a closing bracket right at the end.

  convert(numeric(10,2), convert(numeric(10,2), IsNull(Run, 0))

  could be re-written as

  convert(numeric(10,2), IsNull(Run, 0))

  The IsNull is just substituting 0 if the value of Run is NULL. The convert is forcing the 0 back to 0.00