Home Forums SQL Server 2008 SQL Server Newbies Which is better (Case, IsNull, COALESCE) RE: Which is better (Case, IsNull, COALESCE)

  • November 19, 2013 at 5:39 pm

    #1667637

    Thanks..

    So Do I understand correctly that coalesce would be best in a situation like this>

    COALESCE(myalpacolumn,mynumcolumn,mybinarycolumn,'') As mycolumn