×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
OK, that's and odd request. This would work, but it's ugly:
Select key, desc, 1 from table where key='a' union
Select key, desc, 2 from table where key='c' union
Select key, desc, 3 from table where key='d' union
Select key, desc, 4 from table where key='b'
Order by 3
However, is that actually what you're trying to do? Or is it more like
the key field is a FK reference to another table, and you want to sort
on the description in that other table and the order results in the key
in your table sorting as a, c, d, b? If so, just join and sort on the
right field.
-Walden
--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com
Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
midrange.com
