>Hello comunity,
>
>I have VFP Cursor named mybolist with character field payment.
>Then i need to select this cursor into a new cursor to create condition on payment Field.
>
>

>select payment from mybolist
>The Result is PAYPAL
>
>When i write this new cursor:
>select  Icase(payment='MB', 'MB', payment='CC', 'VISA', payment='PAYPAL','PAYPAL') as 'Payment'  into cursor Mycrs Readwrite
>The result is PA  ??
>

>
>To solve this problem i rewrite like this:
>

>select  Icase(payment='MB', 'MB    ', payment='CC', 'VISA  ', payment='PAYPAL', 'PAYPAL') as 'Payment'  into cursor Mycrs Readwrite
>The result inow is  PAYPAL
>
>
>
>

>
>I deduced that the result must have the length of the string with more characters, why !?
>
>Many thanks,
>Luis Santos

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

Hello Tore,

Many thanks for your reply and also the trick using CAST() :)

Best regards,
Luis Santos