• Home
 · 
• Miscellaneous
 · 
• To Validate Database Null Values

To Validate Database Null Values

To Validate Database Null Values

Rate To Validate Database Null Values

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

    'To validate NULL value
    On Error GoTo LOCALERRORHANDLER
    If IsNull(strPVAL) Then
        fnNULL = ""
    Else
        If IsNumeric(strPVAL) Then
            fnNULL = strPVAL
        Else
            If strPVAL <> "" Then
                fnNULL = Replace(strPVAL, " ", " ")
            End If
        End If
    End If
    Exit Function
LOCALERRORHANDLER:
    fnNULL = ""
End Function