>>>>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.
>
>0 and .f. are empty for numeric and logical fields.


Can I hide these empty values from display ?? (In Browse..)