I know this is a Database 101 quesiton, but when I return a recordset from a DB Table and a column is NULL, what is the best way to handle it before loading the value into a control, such as a textbox?
I was thinking about just writing a routine like this:
Public Function CheckForNULLs(ByVal fld As Object) As String
If IsDBNull(fld) Then
Catch ex As Exception
EH.ErrorMessage = "CheckForNULLs() - " & ex.Message & "...Contact Engineering!" & "~E"
Would this work?