Post reply

what is "!="

  • September 8, 2009 at 8:57 am

    #135312

    Some of our procs use != within where clauses. Can someone explain the difference?

    example:

    SELECT @count = COUNT(*)

    FROM dbase_name..table_name

    WHERE type_cd != 'D'

    AND NOT (rec_id = '00001' AND type_cd = 'A')

  • September 8, 2009 at 9:00 am

    #1050575

    Oops. Meant to edit, not re-submit. See below.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • September 8, 2009 at 9:00 am

    #1050576

    Means the same as or NOT type_cd = 'D'. "Not Equal".

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

  • September 8, 2009 at 9:03 am

    #1050579

    that's simple enough! thanks.

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

You must be logged in to reply to this topic. Login to reply