My requirement is
select * from table a where ID like 'delr' || trim(substr(busns_asct_id,5)) || '%';
based on the above quey
got records like "delr112591-8218-1","delr112659-8323-1" but in that i need to eliminate ID like "delr60201-T","delr99999-A" and "delr1 -5"
Thanks. Based on my Query
select * from table A where ID like 'delr' || trim(substr(busns_asct_id,5)) || '%';
got 145 in that 21 records are like delr60201-T,delr99999-A and one record is in delr1 -5. I need to fetch only 125 data like delr112591-8218-1 etc. Need to eliminate the 22 records which is in the format mentioned above.
"I need to fetch only 125 data like delr112591-8218-1 etc"
delr60201-T is like 'delr112591-8218-1 etc' - you'll need to be more precise in which records you are trying to eliminate i.e. what differentiates all of them from the ones that you are trying to keep. Why is delr112591-8218-1 OK to keep but not delr60201-T?
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.