Re: Funny result set in SQL query

That's correct. The underscore is a matches ANY character:

    Select table_name from dba_tables where table_name like 'PRO_';

could return stuff like

    'PROA'
    'PROB',
    'PROX'

etc.

--
Karl
Oracle Certified DBA
Christopher Jusitce wrote in message <34bad3cb.806387_at_news.erols.com>...


>Try the following query...

>

>SELECT TABLE_NAME FROM SYS.DBA_TABLES WHERE TABLE_NAME LIKE 'PRO_%;

>

>If you have tables like PRO_ACCOUNT and  PROACCOUNT, it will return

>both tables!!!

>

>Wierd,

>

>Chris

>

>justice_at_platinum.com