Path: news.easynews.com!easynews!sjc-peer.news.verio.net!news.verio.net!sn-xit-01!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail
From: farrellyr@yourfuture.ab.ca (Rob F.)
Newsgroups: comp.databases.oracle.server
Subject: problem selecting max value
Date: 10 Oct 2001 08:36:01 -0700
Organization: http://groups.google.com/
Lines: 9
Message-ID: <25f83890.0110100736.235027bc@posting.google.com>
NNTP-Posting-Host: 216.208.100.254
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1002728161 7924 127.0.0.1 (10 Oct 2001 15:36:01 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2001 15:36:01 GMT
Xref: easynews comp.databases.oracle.server:120829
X-Received-Date: Wed, 10 Oct 2001 08:48:03 MST (news.easynews.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.