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