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 PAYPALI deduced that the result must have the length of the string with more characters, why !?