select cast(Icase(payment='MB', 'MB', payment='CC', 'VISA', payment='PAYPAL','PAYPAL') as c(6)) as 'Payment' into cursor Mycrs Readwrite >Although my "standard" way, wrapping the ICASE in some form of PadL/PadR is supported now not only in vfp, your solution is much better fit for any SQL backend. Note to self posted...