I have a table named customer with P.K CName that contains the names of customers. One of the customers is called "Cash".
I want to get a list of all CName with "Cash" to be the first retrieved item.
I used the following query to put "Cash" at the top of the list but the results are still sorted and "Cash" is still in the middle of the list
SELECT 'Cash'
FROM Customer
union
SELECT CName
FROM Customer
WHERE CName<>'Cash'
I think the sorting was applied after the union. Is there a way to perform this kind of custom sort?