Home Forums SQL Server 2008 T-SQL (SS2K8) Best way to handle Null values RE: Best way to handle Null values

  • October 29, 2012 at 4:17 pm

    #1553944

    For what I understood, there's one condition missing in the previous solutions.

    Here's my guess (since I have nothing to test on)

    Declare

    @OrdNbr CoNumType

    Select ISNULL( order_nbr, 'xxxxxx') order_nbr, field1, field2, field3

    from table

    where order_nbr = @Ord_nbr

    OR( order_nbr IS NULL AND @Ord_nbr IS NULL)

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2