Home Forums SQL Server 2008 SQL Server 2008 - General Implicit conversion using COALESCE or CASE RE: Implicit conversion using COALESCE or CASE

  • July 5, 2013 at 1:30 pm

    #1630185

    ISNULL() has its own oddities:

    DECLARE @var1 char(1)

    SET @var1 = NULL

    SELECT ISNULL(@var1, 'N/A') -- Result = 'N'

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.