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)