Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL code problem

Re: SQL code problem

From: William Frye <wfrye_at_mnsinc.com>
Date: 1997/01/31
Message-ID: <5csr3m$1fb@news1.mnsinc.com>#1/1

AlexJent (alexjent_at_aol.com) wrote:

: --Why no rows selected when I have this statement?
 

: --select desc, code from table_a where name = 'ABC'
: --and code like '3%' and code like '7%' ;
 

: Try changing code as follows: "and code like '3%' OR code like '7%' ; Received on Fri Jan 31 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US