Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Simply question about TO_NUMBER function

Re: Simply question about TO_NUMBER function

From: MariMax <massimo.panero_at_powertiscali.it>
Date: Thu, 3 Feb 2005 10:07:04 +0100
Message-ID: <36e7tpF51838nU1@individual.net> 






"Tom Dyess" <tdyess_at_dysr.com> ha scritto nel messaggio
news:u1fMd.23624$t67.10929_at_bignews5.bellsouth.net...


>

> SELECT  *  FROM  Table1  WHERE  Field1 = TO_CHAR(456)

>




It don't work because if i have values '456' and '0456' and '00456', i want
the query return three records not only the first.
I can't define the field NUMERIC because it may be alphanumeric.
Received on Thu Feb 03 2005 - 03:07:04 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US