Re: Avoiding ORA-01722 Invalid Number

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 7 Jun 2005 00:00:46 -0700
Message-ID: <1118127646.047349.319280@g49g2000cwa.googlegroups.com>

SELECT *
  FROM ( SELECT *
           FROM ( SELECT TRANSLATE( charcol,

'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz',

'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx') charcol

                    FROM t1 )
          WHERE charcol NOT LIKE '%x%' )

 WHERE charcol BETWEEN 20 AND 30
/

Cheers.

Carlos. Received on Tue Jun 07 2005 - 02:00:46 CDT