This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Instant DB , to_number function Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Instant DB , to_number function" Watch "Instant DB , to_number function" New topic

Instant DB , to_number function

Natraj Gudla
Ranch Hand

Joined: Feb 09, 2003
Posts: 34
I was working with the instant DB , and was in need of a query which will sort a field of a table in ascending order.the field type is character,but contains numeric values(1,2,3etc).so said like select * from table_name order by to_number(field_name) , it raises an error that to_number is applicable to date fields.can this problem be solved , if so how.
Also i would like to know whether the same can be done in Mysql.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: Instant DB , to_number function
Similar Threads
To_number function not work with decode function.
to_number function question.
[SQL] varchar2 to number
Oracle SQL Order by solution
How to create table dynamically in JDBC?