Archives of the TeradataForum
Message Posted: Thu, 24 Jan 2008 @ 11:23:52 GMT
| Subj: | | Re: Confusing of the 'NOT LIKE' logic |
| |
| From: | | David Clough |
For what it's worth, whenever this type of confusing arises here at TNT
I always recommend starting off with reversing the logic, eg
SELECT Something OR Other FROM Howsyourfather;
and then apply the NOT to that :
SELECT NOT(Something OR Other) FROM Howsyourfather;
Honestly, it makes complex OR's and AND's a lot easier to code.
Dave Clough
Database Designer
Express ICS
www.tnt.com
| 
