> > >>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. Store it as it is, and then if empty(field_name) blank field (field_name) endif so it will be blank.