Re: SQL Select statement

"Tony Andrews" <[email protected]> Thu, 30 Jan 2003 12:30:18

Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-854534-2003.01.30-12.15.50--gcdod-oracle#[email protected]>

1) Any other method if I don't want to use OR ?

Yet another way is:

WHERE NVL(col,'xxx') LIKE 'SMI%'

But beware this will not make use of an index on col, if there is one.
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].