Try this,
SELECT AT( CustType, 'QWER' ) as OrderField from tablename order by OrderField
>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
Shane Murdoch