Subject | ORDER BY and TERM CHAR |
---|---|
Author | R1 xyz |
Post date | 2003-09-08T03:44:26Z |
Hi,
This SQL statement (fragment only shown)
+ ' ORDER BY ' + fld;
behaves different depending on whether there is a term char.
If no term char (';') it will order without regard to case.
if, however, the term char (';') is added, the ordering
is case sensitive.
Can I count on this behavior?
Is this the way it is intended to work?
Thanks,
Roger
________________________________________________________________
The best thing to hit the internet in years - Juno SpeedBand!
Surf the web up to FIVE TIMES FASTER!
Only $14.95/ month - visit www.juno.com to sign up today!
This SQL statement (fragment only shown)
+ ' ORDER BY ' + fld;
behaves different depending on whether there is a term char.
If no term char (';') it will order without regard to case.
if, however, the term char (';') is added, the ordering
is case sensitive.
Can I count on this behavior?
Is this the way it is intended to work?
Thanks,
Roger
________________________________________________________________
The best thing to hit the internet in years - Juno SpeedBand!
Surf the web up to FIVE TIMES FASTER!
Only $14.95/ month - visit www.juno.com to sign up today!