Say I wish to do a SELECT query and sort on a text column, but I want to pick
two or three (or however many) specific values, designated by constant string
values, to sort to the top.  Can this be done with standard SQL?

If you get what I'm talking about, it might be something like:

ORDER BY textfield 'joe' 'dave' ASC

Or maybe with subselect or union?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to