Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Server nulls and VB Nulls

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-29 : 22:37:11
Jim writes "I'm passing some parameters from a vb object to a stored proc in SQL Server 7. If I understand correctly, vbNull and Null datatypes are not true null characters from within VB, and in passing them to a stored procedure, I can't get the stored proc to catch the VB Null character when checking "is null"...
Any way to convert the variable to a true null?

-----------------------------
W2K Server w/service pack 1
SQL Server 7.0 /service pack 2
-----------------------------
Thanks..."
   

- Advertisement -