Re: Using Not Equal in VIEW
From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 11/30/04
- Previous message: WJH: "Re: Order By Clause"
- In reply to: mbmccoy: "Using Not Equal in VIEW"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 30 Nov 2004 23:15:12 -0000
Change AND to OR. For example:
...
WHERE co_code <> 'ATLN' OR service_code <> 'PL'
-- David Portas SQL Server MVP --
- Previous message: WJH: "Re: Order By Clause"
- In reply to: mbmccoy: "Using Not Equal in VIEW"
- Messages sorted by: [ date ] [ thread ]
