Results 1 to 3 of 3
Thread: Sorting Alphanumeric+dots
Jun 3, 2003, 00:19 #1
- Join Date
- Jul 2000
- 0 Post(s)
- 0 Thread(s)
I'm try to sort a column in mysql db that contains numbers, letters and dots.
It should sort to:
How do i do that? A normal ORDER BY would not work with the .30 and .3
The column type is VARCHAR. I tried looking at the mysql doc, and some user comments suggested SOUNDEX and ORD but it doens't seem to work for me. Any ideas?
Thanks."Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world."
-- Albert Einstein