Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2005 @ 16:11:48 GMT

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

Move your "Not" to the front of "upper" like so:

     select
        store_code,
        format_description
     from
        stores
     where
        not upper(format_description) like any ('%LOCAL%','%CENTRAL%')
     ;

(Mike Larkins would be proud... He was my first SQL mentor ya know...)

Chris Coffing
Air Force Knowledge Services (AFKS)
Lead DBA Operations & Support
Teradata Certified Master

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