That suggests that the field value is already null. IsNull () would return false for an empty string.<BR><BR>SQL Server provides the NullIf () function, which does what you want; depending on your ...

This article is also available as a PDF download. Where errors are concerned, null values are an equal-opportunity menace. If an unhandled null value doesn’t generate a runtime error, it’ll show up in ...