[EMAIL PROTECTED] wrote:
Hi,
I need urgent clarification on the following behaviour with the following queries.
I have a table called playlistTable as follows.
CREATE TABLE playlistTable( iPlaylistId INTEGER PRIMARY KEY,cPlaylistName VARCHAR(100), cFileName VARCHAR(255),iDirId INTEGER );
CREATE INDEX playlist_cPlaylistName ON playlistTable (cPlaylistName);
I have two queries as examples and the output as follows.
QUERY 1:
select * from playlistTable order by iDirId, cPlaylistName collate nocase
30 APlayList30 NO FILE 0 29 bPlayList29 NO FILE 0 27 ccPlayList27 NO FILE 0 26 cPlayList26 NO FILE 0 28 CPlayList28 NO FILE 0
Query 2 select * from playlistTable order by cPlaylistName,iDirId collate nocase
30 APlayList30 NO FILE 0 28 CPlayList28 NO FILE 0 25 DPlayList25 NO FILE 0 1 PlayList1 NO FILE 0
In 2, only iDirId is sorted nocase.
Try select * from playlistTable order by cPlaylistName collate nocase,iDirId
Gerry -- ------------------ Gerry Snyder AIS Director, Affiliates Chair, Symposium Chair in warm, winterless Los Angeles -- USDA zone 9b, Sunset 18-19
