Forums

ASP

This topic is locked

sorting database records

Posted 11 Mar 2002 18:18:59
1
has voted
11 Mar 2002 18:18:59 chris merrill posted:
Hello,
When sorting database records, I would like certain records to show up first. Is it documented anywhere, which special characters will appear before the letter A?
thx.
cm<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Replies

Replied 12 Mar 2002 18:45:43
12 Mar 2002 18:45:43 Joel Martinez replied:
that's a great question... and unfortunately not one that I've seen answered in the past. I think your best bet is to do some testing.
-make a test database with some of the characters in question.
-order a query by that field and voila, your answer.

Joel Martinez
MX inSite Magazine
The Complete Resource for Macromedia designers & developers
Sign up for your free electronic Preview Issue
www.mxinsite.com

Reply to this topic