>>hello everybody,
>>
>>in a table I have a field named CustType, which can only have 4 values: Q, W, E, R
>>
>>I want to sort the table by CustType, but neither in ascending(EQRW) nor descending(WRQE) order, I want the order to be Q,W,E,R. Is it possible?
>>
>>Are there any VFP commands can do this?
>>Is it possible to sort the table in this order, when I'm selecting data with SQL statement?
>>Which way is better?
>>
>>Thanks a lot!!
>>Jimi
>
>I would use a UDF:
>
>

>function CustomerSort(tcType)
>do case
>case tcType = "Q"
>  return "1"
>case tcType = "W"
>  return "2"
>...
>

>
>Another possibility is nested IIFs in the SELECT statement itself.
>
>Hilmar.

Yeah it's exactly what I'm doing now :)