# Treatment of NULLS

In a delimited file, a NULL value is exported as an empty field. The following example shows the export of a four-column row in which the third column is NULL:

    7,95,,Happy Birthday

Import works the same way; an empty field is imported as a NULL value.

Parent topic: Bulk import and export
Related concepts
Importing into tables with identity columns
Executing import/export procedures from JDBC
File format for input and output
Related reference
Bulk-Import
Bulk-Export
Examples of bulk import and export
CODESET values for import/export