The problem is the variable size of the result. The first record which Visual FoxPro finds, in this case, might not fulfil the condition in the IIF(), and, therefore, return 0 (size: 1 byte). Then, VFP decides that this is the correct size for the rest of the table - and you get the asterisk (which means, "the result does not fit").

In general, you should avoid variable-sized results in a SELECT - SQL command - or at least make sure that the minimum size of a field is big enough.

>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