Hi,

I'm try to sort a column in mysql db that contains numbers, letters and dots.

Eg.

1.4.1a
1.2.3
1.2.30
1.4.5

It should sort to:
1.4.5
1.4.1a
1.2.30
1.2.3

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.