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

Home -> Community -> Usenet -> c.d.o.misc -> sorting character fields

sorting character fields

From: Steve Raftery <sraft_at_webvision.com>
Date: 1998/03/11
Message-ID: <3506CFAD.167E@webvision.com>#1/1 







Is there a way to sort character fields numerically.
The character fields I am sorting sometimes contain numbers and
sometimes contain characters. If I use the function
to_number(field_name) and a character is in the field I get an
invalid number error and the whole query fails.

-- 
Steve Raftery

Webvision
19950 Mariner Avenue
Torrance, CA 90503
www.webvision.com


Received on Wed Mar 11 1998 - 00:00:00 CST












Original text of this message













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