>>>>> l'ha dit:

chris> Hi there, We are using external files. We have varchar data
chris> with nulls in FB. When exporting this data to an external
chris> file, upon hex examination, a null value appears to be a
chris> series of NUL characters.

I think you should declare the external table fields as CHAR(n), not
as VARCHARs. The former is a fixed length field, so it keeps the
trailing spaces without NULs.

hth,
ciao, lele.
--
nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.