Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Query with 'LIKE' comparison questions
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
![]() |
![]() |