>I just did a left outer join and in the result set
>i have fields with a .NULL. value.
>
>I would like to replace just the .NULL. valued fields
>with a default value, let's say 10 (it is a numeric field).
>
>However, I was unable to find the first .NULL. field
>when trying the below commands:
>
> LOCATE FOR nfld = .NULL.
>
> LOCATE FOR EMPTY(nfld)
>
>In both cases I am brought to the end of the file.
>
>How can I consistently find the .NULL. valued fields?
locate for isnull(nfld)
However, you may also change your outer join syntax to provide default values in first place.
Edward Pikman
Independent Consultant