Jason: I just tested the select statement on the table where I get the data and added "where payrate is null" and the row did come up, so it appears to be a valid null.
Karen > Karen, > Are you sure that vBillRate is NULL, and not some oddball unprintable > character? > What happens if you load all your variables with a SELECT INTO > statement and then INSERT using > INSERT INTO sales (collist) VALUES (.var1,.var2,etc...)? > Jason
