>As Martina wrote, this is a "feature". My preferred workaround is to use Cast:
>
>

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