Re: SQL Sort Question

2004-02-14 Thread Jochem van Dieten
Jim McAtee wrote: 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

SQL Sort Question

2004-02-13 Thread Jim McAtee
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