var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ORDER BY Canada, Unisted States then
In a country list I would lint the order to be: ORDER BY Canada, United States,
then the rest of the countries alphabetical. Would I need to do two UNIONs?
WHEN country_name = 'Canada' THEN 'AAAAAA'
WHEN country_name = 'United States' THEN 'AAAAAB'
I didn't realize CASE could be used except in a SELECT statement! Can it be used in the WHERE?
So if I have list of countries and I want one or two of the countries a the top and the rest alphabetically, this will do it?
what happened when you tested it?
Originally Posted by oldnickj
OK, your right, it works!
CASE is a lot more interesting than I thought.