>>But of course. I'm assuming here they're all alpha-numeric :-)
>
>BTW I don't see any reasons to keep numeric data in CHAR fields :-)
Nor I. But I've had to deal with this very same problem (especially getting in numeric order) when taking over, maintaining and further developing, or redeveloping, legacy systems. Even had the author of one such system, before I took it over, asking me the same question about how to get it in the correct order.
Well DUH_UH! :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.