aspose 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
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
 
Similar Threads
Oracle SQL Order by solution
[SQL] varchar2 to number
How to create table dynamically in JDBC?
To_number function not work with decode function.
to_number function question.