[thelist] Sorting with SQL

Ken Moore cor412 at hotmail.com
Wed Sep 24 12:29:19 CDT 2003

Hi all,

As a database programmerof 20 years, this is what I would do. I would modify 
the table structure to isolate the item or items that will be used in 
sorting and selecting. Otheriwse, you will constantly be rigging schemes to 
make it work.

Using substring functions etc. will work but they are difficult and very 

Ken - Who has made that mistake too many times

>>In some cases I will have:
>>    LLL N-N
>>    LLL NN-N
>>    LL N-N
>>   .:. Where L stands for Letter and N stands for Number

Share your photos without swamping your Inbox.  Get Hotmail Extra Storage 
today! http://join.msn.com/?PAGE=features/es

More information about the thelist mailing list