>> >> The problem is this only, If I return 0 for numeric and .f. for
>> logical,
>> >> the fields which should be left blank are filled with these values.
>> >>
>> >> If I try to return null, its not accepting, as the cursor which select
>> is
>> >> making is not supporting null values.
>> >>
>> >> Pls advs, I want to make those fields empty and not 0 or .f.
>> >
>> >One Pre-VFP way of doing this is to return an extra logical field
>> >indicating whether or not the field was empty. Now that we have VFP, we
>> >can return .NULL.
>> >
>> >/Paul
>>
>> I have tried returning .null. but it is giving error msg. You can try this
>> by creating a cursor file with select..
>>
>> Pls advs your suggestions
>
>Have a look at the ISNULL() function.
>
>browse F1=iif(isnull(field1),"",field1) :20, ;
> F2=iif(field2," X "," "), ;
> F3=field3 :P="@Z 9999.99"
>
>field1 is a Character field that allows .NULL.s
>field2 is a Logical field that we want an "X" displayed in if .T., and
>nothing if .F.
>field3 is a Numeric field that we don't want displayed if 0
>
>/Paul


Thanks for your reply and so much help, Actually I should be more clear, For browse purpose this method will definately work, but i want to transfer it in a text file also. So, what actually I want is that table/cursor itself should have blank fields, so that I can easily export it. Pls advs your comments/suggestions..