Re: Query with 'LIKE' comparison questions

Short term fix:

SELECT * FROM table WHERE acct_num IN (
:val,

lpad(:val,1,'0'),
lpad(:val,2,'0'),
lpad(:val,3,'0'),
lpad(:val,4,'0'),
lpad(:val,5,'0'),
lpad(:val,6,'0'),
lpad(:val,7,'0'),
lpad(:val,8,'0'))

(Replacing :val with whatever value you are querying for, and extening the lpad value as high as it needs to go) Received on Wed Oct 12 2005 - 15:46:20 CDT