Help me about charactef function!!

From: wajim <wajim29_at_hotmail.com>
Date: Tue, 31 Jul 2007 01:26:47 -0700
Message-ID: <1185870407.621316.210590@k79g2000hse.googlegroups.com>

Hi all,
I have a work on a table that I already created and populated with some values, numeric and non-numeric(alpha-numeric), the qustion is How can I sort all values from the column in numeric order?? This is the table I created:

SQL> select * from test_numb;

COLUMN_1

---

1
10
3
34
7
6
43
3-A
17-B
3-B

10 rows selected.

So it concerns the values 3-A, 17-B and 3-B I know there is a function ASCII(..) but don't see how to insert it in a select tatement;
Thanks in advance. Received on Tue Jul 31 2007 - 03:26:47 CDT