>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
Mark McCasland
Midlothian, TX USA