I have this query and plan to use it to populate a drop down box. I want the --Select-- option to be the first on the list and I still want to be able to sort by lastname ascending. Right now when I sort it is not making the --select-- the first item.
select '' as id,
'--select--' as lastname
select id, (lastname + ',' + firstname) as "Fullname"