Home Forums SQL Server 2008 SQL Server Newbies Case statements advice - query case field? RE: Case statements advice - query case field?

  • August 12, 2013 at 7:15 pm

    #1640757

    dwain.c (8/12/2013)

    Alan.B (8/12/2013)

    Instead of the case statement you can also do this:

    SELECT ISNULL(thing1.name,(ISNULL(thing2.name,thing3.name))) AS name

    And why not:

    SELECT COALESCE(thing1.name,thing2.name,thing3.name) AS name

    ?

    Nice. That is cleaner and easier to read.

    +1

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001