[Cialug] Alphabetical Sort

[Patrick Mcgillan]

I have this problem where a SQl field contains characters like this in
different records.

1.4.1
1.4.10
1.4.2
1.5.1
1.5.10
1.5.11
1.5.12
1.5.2
1.5.3
Trouble is, 1.4.2 should sort out before 1.4.10, but because it is a
character field it doesn't. Now that makes perfectly good sense to me, but
not the customer. I can't sort on ID as the entries are randomly done. I
sense that this problem has been solved before, but can't put my finger on
it.

Can anybody point me in the proper direction.

Patrick