i was trying to do the following

select date,ncurrency,iif(ncurrency=2,famt,0),iif(ncurrency=1,famt,0) from tbmain into cursor vwx

but for some reason if ncurrency=2 then the value comes as a *,

also if i just do

select date,ncurrency,iif(ncurrency=2,famt,0) from tbmain into cursor vwx

it gives me a *

but this works fine

select date,ncurrency,iif(ncurrency=1,famt,0) from tbmain into cursor vwx

what gives?