locked
NOT and NULL Values RRS feed

  • Question

  • Can someone please tell me (or point me in the direction of some reading) why the NULL is not coming through on this query.

    Select * From 
    (
        Select 
            * 
        from
        (values
            (NULL),
            ('Val1'),
            ('Val2')
        ) A(S_ID)
    ) A
    Where
    NOT (S_ID = 'Val1')

    Thanks

    T

    Thursday, December 5, 2019 1:11 PM

Answers

All replies