>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 ?? >>
>select Icase(payment='MB', 'MB ', payment='CC', 'VISA ', payment='PAYPAL', 'PAYPAL') as 'Payment' into cursor Mycrs Readwrite >The result inow is PAYPAL > > > >>
select cast(Icase(payment='MB', 'MB', payment='CC', 'VISA', payment='PAYPAL','PAYPAL') as c(6)) as 'Payment' into cursor Mycrs ReadwriteHello Tore,