Re: Order By Problem

[Russ Wulfson <rwulfson@BOST.COM>]

You need a method of assigning an ordinal value to a list that is
inherently illogical(in terms or sort order).  If the list of categories is
relatively fixed.  You can create an sqc that contains the field values and
the assigned ordinal value.  Then you can use a variety of methods to get
them in the order you want - temp tables, passing the ordinal value to the
select over and over, maybe even using an array.  However, if the list can
change at any time in any way, your out of luck.