Correct

SELECT ... INTO ... FROM ....WHERE someStringColumn is null;

In general, if the Cúram data type corresponds to a Java class (as opposed to a primitive Java type) then its empty state is stored on the database as a null. If the data type corresponds to a primitive Java type then a null on the database is not a valid value for it and theAllow NULLs on this database field option defaults to no. If necessary this default can be overridden.

Note: TheAllow NULLs on this database field option controls the NOT NULL qualifier in generated DDL in an inverted way. Setting this option to no causes the NOT NULL qualifier to be added; setting it to yes causes the qualifier to be omitted.

The following table shows which Cúram data types can be represented as a null on the database.

Table 1. Data types and nulls
Datatype	Nulls allowed
SVR_BLOB	yes
SVR_BOOLEAN	no
SVR_CHAR	no
SVR_DATE	yes
SVR_DATETIME	yes
SVR_DOUBLE	no
SVR_FLOAT	no
SVR_INT8	no
SVR_INT16	no
SVR_INT32	no
SVR_INT64	yes
SVR_MONEY	no
SVR_STRING	yes