File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Instant DB , to_number function" Watch "Instant DB , to_number function" New topic
Author

Instant DB , to_number function

Natraj Gudla
Ranch Hand

Joined: Feb 09, 2003
Posts: 34
Hi,
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Instant DB , to_number function