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 browsewhat i see in the returned cursor are '*' where the negative integers are present