A database table "myTable" has the field "category";
SELECT DISTINCT "category" FROM "myTable" ORDER BY "category" ASC;
A-Class
T-Class
Z-Class
OK, now I have to add a line 'undefined', e.g.
SELECT DISTINCT "category" FROM "myTable"
UNION SELECT '>undefined<'
ORDER BY "category" ASC;
A-Class
T-Class
>undefined<
Z-Class
I need the 'undefined' as first entry in the list and tried several characters like .,-_<>! at the first place, but all are ignored and the u is taken for the order.
Is there any simple option to achieve this, without showing a second column in the query?