Home Forums SQL Server 2005 Development ISNULL in a CASE statement??? RE: ISNULL in a CASE statement???

  • January 21, 2008 at 8:15 am

    #770159

    You could change your case statement like:

    CASE

    WHEN [myRow] = 1 THEN 'True'

    WHEN [myRow] IS NULL THEN 'False'

    ELSE 'FALSE'

    END

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software