i have a table which displays information from out database. some of the fields in the database are null...no problems there. howerver, when the information is displayed in the table, the border attributes for the fields with null values disappear. is there a way to keep the html attributes for field with null values b/c it really makes the table look bad. Thanks for any help. i'm also using classic ASP, not ASP .NET. thanks

nevermind...i figured it out

Also Nulls such as in variables can be a problem when trying to use them in comparisons. So I usually convert things like text fields from a database that could be Null to be "" instead of Null:

MyVar = jpsvbNullToBlank(MyVar)

Function jpsvbNullToBlank(pvarFld)
' Convert Null to blank.
If IsNull(pvarFld) Then
jpsvbNullToBlank = ""
Else
jpsvbNullToBlank = pvarFld
End If
End Function