Hi I'm using the following query to first, display in asc order any records that have something in the language column, then any fields where the language column is an empty string (fyi I don't have nulls in this column). It works perfectly.
I'd now like to order the Language = "" rows by another column, "Artist", but cannot crack how to restructure the query to accommodate this. SELECT * FROM (SELECT * FROM table1 WHERE Language !="" COLLATE NOCASE ORDER BY Language COLLATE NOCASE) UNION ALL SELECT * FROM table1 WHERE Language ="" COLLATE NOCASE LIMIT 100 Is it possible, and if so, would you mind showing me how? Thanks for your time and help. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
