Message
From
11/12/2006 09:59:31
To
11/12/2006 08:32:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Sql order by
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
SAMBA Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01176457
Message ID:
01176542
Views:
11
>>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! :-)
>
>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.
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.