InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Drew

You'd probably have to write a function, text_to_number say, and then 
do something like:

SELECT my_text, text_to_number (my_text) FROM mytable ORDER BY 2

Writing a function is easy. There are lots of examples in the functions 
directory. Just take any one as a template, edit it, compile and add 
the result to your classpath.

Pete

----- Original Message -----
From: Webmaster <webmaster@bigpineapple.com.au>
Date: Tuesday, March 6, 2001 2:30 am
Subject: InstantDB: HELP URGENT

> Hi all,
> A bit off topic but how do I sort a text field on a numeric sort. My
> primary key is text so 100 sorts less than 2.
> 
> Thanks
> 
> Drew
> 
> -------------------------------------------------------------------
> ----------
> To unsubscribe from this mailing list, send email to 
> majordomo@enhydra.orgwith the text "unsubscribe instantdb" in the 
> body of the email.
> If you have other questions regarding this mailing list, send 
> email to
> the list admin at owner-instantdb@enhydra.org.
> 

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.