Help with COALESCE logic - is it the same as this query?

• Pete T-366679

  SSCrazy

  Points: 2065

  More actions

  February 15, 2008 at 11:50 am

  #378536

  I think this works, but just want to make sure....I have the following query snippet:

  AND

  (

  (CodeType = 'Task Type' AND AccountID = 1)

  OR

  (CodeType IS NULL AND AccountID IS NULL)

  )

  Could this be accomplished by this:

  AND COALESCE(CodeType , 'Task Type') = 'Task Type'

  AND COALESCE(AccountID , 1) = 1

  Do I gain anything by getting rid of the 'OR'? Is one more clean than the other?

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  February 15, 2008 at 11:58 am

  #778964

  In my understanding, they are functionally the same. The benefit I see is that it's easier to read using COALESCE.

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg

• Pete T-366679

  SSCrazy

  Points: 2065

  More actions

  February 15, 2008 at 12:06 pm

  #778968

  Jason Selburg (2/15/2008)

  ---

  In my understanding, they are functionally the same. The benefit I see is that it's easier to read using COALESCE.

  Thanks, that was my thinking, too regarding the 'easier to read'. Thanks again!