>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?

a) Create a cursor CustTypes and populate it with

CustType   OrderPos
-------------------
Q          1
W          2
E          3
R          4

b) Cross tables, using the order set in the types cursor

SELECT Customers.* ;
FROM Customers ;
  INNER JOIN CustTypes ON CustTypes.CustType = Customers.CustType ;
ORDER BY CustTypes.OrderPos