Welcome to the Lounge

Lopatir wrote:

beans, particularly baked beans / chilli beans are known to produce music

WITH cte As
(
    SELECT '1 America' As CountryName
    UNION SELECT 'Albania'
    UNION SELECT 'Zimbabwe'
)
SELECT CountryName
FROM cte
ORDER BY CountryName COLLATE SQL_EBCDIC037_CP1_CS_AS;

/*
Output:

CountryName
------------
Albania
Zimbabwe
1 America
*/

WITH cte As
(
    SELECT '1 America' As CountryName
    UNION SELECT 'Albania'
    UNION SELECT 'Zimbabwe'
)
SELECT CountryName
FROM cte
ORDER BY CountryName DESC;

/*
Output:

CountryName
------------
Zimbabwe
Albania
1 America
*/