I need to sort on a field that has address numbers. Some are strait numbers, (1223) some are numbers and letters (123 A), and some are numbers and fractions (123 1/2). How can I approach sorting so that I can get results such as 1 2 3 A 4 5 25 231/2 26 B, etc.

Thank you,

Bob

Bob Peterson
Foster, RI
[email protected]

hi there...

you want to sort letters in the middle of numbers?? or complete fields??? because there is no logical explain (even outside programing) to have A between 3 and 4... can you write a better example??
(original fields, sorted fields, some idea that explain how to sort that way)...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========