Re: Funny result set in SQL query

You can escape the '%' or '_' by using the ESCAPE option:

    Select table_name
    from all_tables
    where table_name like 'PRO\_%' escape '\'

this will require an exact match on the underscore because it is prefixed by '\'

--
Karl
Oracle Certified DBA