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: Query with 'LIKE' comparison questions

Re: Query with 'LIKE' comparison questions

From: <casey.kirkpatrick_at_gmail.com>
Date: 12 Oct 2005 13:53:28 -0700
Message-ID: <1129150408.801153.218220@g49g2000cwa.googlegroups.com>


Oops that was a bit sloppy...(this is why you should always preview first)... I meant:

SELECT * FROM TABLE WHERE acct_num IN (
:val,

LPAD('0',1,'0')||:val,
LPAD('0',2,'0')||:val,
LPAD('0',3,'0')||:val,
LPAD('0',4,'0')||:val,
LPAD('0',5,'0')||:val,
LPAD('0',6,'0')||:val, 
LPAD('0',7,'0')||:val, 
LPAD('0',8,'0')||:val)
Received on Wed Oct 12 2005 - 15:53:28 CDT

Original text of this message

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