Michael L. Horne wrote:

> That would be fine, but how do I do it. This field is being
> pulled from another file based on a field in this record, but
> the second field doesn't have to contain a key. So how do I
> write the SQL to make this value default to "F" if the other
> record doesn't exist?

CASE WHEN FIELD IS NULL THEN "F"
ELSE FIELD END

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services