hi
how can is achive what i want?

create cursor foo (f i)
insert into foo values(112)
insert into foo values(11)
insert into foo values(-11)
insert into foo values(-121)

select IIF(f>=0,f,0) as a1, IIF(f < 0,f,0) as a2 from foo
select IIF(f>=0,f,0) as a1, IIF(f < 0,-f,0) as a2 from foo
select foo
browse

what i see in the returned cursor are '*' where the negative integers are present

I want the integers to appear in its place instead of the *

Tia
suhashegde