Null Value

[Eric Lindros]

How do you test for a Null value in a returned recordset from SQL Server 7?

I have tried the following, with no luck:

If (rs("ExtPrice1") = NULL) Then
'some code that never gets executed
End If

What is the proper way to do this?

I have also tried all of the following:

If (rs("ExtPrice1") = "NULL") Then
'some code that never gets executed
End If

If (rs("ExtPrice1") = null) Then
'some code that never gets executed
End If

If (rs("ExtPrice1") = "null") Then
'some code that never gets executed
End If

If (rs("ExtPrice1") = Nothing) Then
'some code that never gets executed
End If

If (rs("ExtPrice1") = "") Then
'some code that never gets executed
End If

[Sudha xxxxxxx]

Try this
If IsNull(rs("ExtPrice1")) then
'Some code
End If

"Eric Lindros" <nobody@nobody.com> wrote:
>How do you test for a Null value in a returned recordset from SQL Server
7?
>
>I have tried the following, with no luck:
>
>If (rs("ExtPrice1") = NULL) Then
> 'some code that never gets executed
>End If
>
>What is the proper way to do this?
>
>I have also tried all of the following:
>
>If (rs("ExtPrice1") = "NULL") Then
> 'some code that never gets executed
>End If
>
>If (rs("ExtPrice1") = null) Then
> 'some code that never gets executed
>End If
>
>If (rs("ExtPrice1") = "null") Then
> 'some code that never gets executed
>End If
>
>If (rs("ExtPrice1") = Nothing) Then
> 'some code that never gets executed
>End If
>
>If (rs("ExtPrice1") = "") Then
> 'some code that never gets executed
>End If
>
>

[Sudha xxxx]

Try this
If IsNull(rs("ExtPrice1")) then
'Some code
End If

"Eric Lindros" <nobody@nobody.com> wrote:
>How do you test for a Null value in a returned recordset from SQL Server
7?
>
>I have tried the following, with no luck:
>
>If (rs("ExtPrice1") = NULL) Then
> 'some code that never gets executed
>End If
>
>What is the proper way to do this?
>
>I have also tried all of the following:
>
>If (rs("ExtPrice1") = "NULL") Then
> 'some code that never gets executed
>End If
>
>If (rs("ExtPrice1") = null) Then
> 'some code that never gets executed
>End If
>
>If (rs("ExtPrice1") = "null") Then
> 'some code that never gets executed
>End If
>
>If (rs("ExtPrice1") = Nothing) Then
> 'some code that never gets executed
>End If
>
>If (rs("ExtPrice1") = "") Then
> 'some code that never gets executed
>End If
>
>