Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Not In

    Agreed on #1

    On #2: In the explanation they say that the problem is basically that NULL is not the same datatype as 'Idle', when I used ISNULL() and replaced NULL...

  • RE: Not In

    Very easy remedy to this problem: ISNULL() function

    select * from Statuses s

    Where ISNULL(s.Stat,'NULL') not in ('NULL', 'Idle')

Viewing 2 posts - 1 through 2 (of 2 total)