>I just opened the ODBC data source administrator and I do not see any options for null values, could you tell me which tab it is under & what the
>options caption says ?

Again sorry for confusion. Please disgregard my suggestion about Nulls option because there's no Nulls option for Sql Server ODBC driver. That option is applicable only to VFP ODBC driver.