![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Fri, 07 Jan 2005 @ 15:58:13 GMT
Subj: | | Re: "NOT LIKE ANY" |
|
From: | | McBride, Michael |
0001 localsmain
0006 localsother
0008 main
0010 centalsmain
upper(format_description) not like any ('%LOCAL%','%CENTRAL%')
The reason nothing is excuded is because, in the first case, 'localsmain' the substring 'local' begins in the first position, %local%
will not excude that row, you would need to add 'local%' to account for starting at the beginning of a value. Secondly, %Central% would not work
for the same reason, but you have an additional problem in that the value string your trying to exclude (I'm making an assumption here) is
'cental' not 'central' (which is may be a typo in the date?
Hope this helps?
Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner
American Eagle Outfitters
| |