Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2005 @ 15:58:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

          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

	<Prev	Next>		<<First	<Prev	Next>	Last>>