You can't use % in an IN clause. One solution is to separate it out with
select distinct col1
where col1 like 'B%'
or col1 like 'E%'
or col1 like 'G%';
However, a better solution is to use Oracle's regular expressions:
SELECT distinct col1
WHERE REGEXP_LIKE (col1, '^[BEG]');
thanks for valuable suggestion..it did help..
Please mark as answered if the question is answered.
how to do that....please let me know..will do that