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 -> problem selecting max value

problem selecting max value

From: Rob F. <farrellyr_at_yourfuture.ab.ca>
Date: 10 Oct 2001 08:36:01 -0700
Message-ID: <25f83890.0110100736.235027bc@posting.google.com> 





I have a column in a table that is a varchar2(15), right now this
column only holds numbers.  I try to select max(column_name) and I get
9999 as the result, but the max in that column is over 30000.  Is this
a problem with selecting max on a column that is varchar2?  Or is
there something else I should be looking at?



7.3.4 - NT4



Thanks.
Received on Wed Oct 10 2001 - 10:36:01 CDT












Original text of this message













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