Re: Funny result set in SQL query

cjustice_at_erols.com (Christopher Jusitce) wrote:

>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

Hi,

What else did you expect ??

'_' is the wildcard for 1 character !

:-) Tolli Received on Tue Jan 13 1998 - 00:00:00 CST