Russell,

In your SQL SELECT statements in the back-end, you can use the ISNULL function to return an alternate value if a column is NULL. For instance.

SELECT ISNULL(LastName,'') AS LastName, SELECT ISNULL(CustomerType,0) AS CustomerType, etc.

Let me know if that helps.

Kevin