>>
>> >>Thanks for your reply and sorry for delay in reply, actually the problem
>> is if the field is other then character field, what value I should return
>> to make it empty.
>> >>
>> >>Pls Advs
>> >>
>> >Vinod:
>> >
>> >You would have to return a value that is of the same type as the field
>> type in the generated select statement. If numeric, you could pass back 0
>> or -1 (pick some default value). If the select field is logical, you would
>> have to return .t. or .f. Again, you would need to test the type of data
>> being passed to the function, and I would do this within the function.
>> Then return a corresponding result type. You could experiment returning
>> .null. if a value is "empty." You may be able to return .null. for empty
>> date, numeric, logical, etc., fields.
>> >
>> >HTH
>>
>> 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