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]
- Re: SQL Sort Question Jim McAtee
- Re: SQL Sort Question Jochem van Dieten