-
sourceuno
- Posts: 225
- Joined: Mon Apr 09, 2001 3:58 pm
Post
by sourceuno »
How can I do a case-insensitive sort in an sql statement? Here's my statement:
<sql "select URL from sites order by URL">
$URL<Br>
</sql>
For example,
www.L.com comes before
www.a.com.
-
John
- Site Admin
- Posts: 2622
- Joined: Mon Apr 24, 2000 3:18 pm
- Location: Cleveland, OH
-
Contact:
Post
by John »
<sql "select URL from sites order by URL nocase">
John Turnbull
Thunderstone Software
