Archives of the TeradataForum
Message Posted: Thu, 24 Jan 2008 @ 13:13:24 GMT
The logical opposite of (A OR B) is NOT A AND NOT B, so that part you have down. However, if url_txt is NULL then I don't believe it will return with NOT LIKE. NULL mixes alot of people up. NULL is neither logically LIKE A nor NOT LIKE A. I'm guessing that the remainder of the records are made up with records with NULL url_txt.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|