I haven't tried it Mike, because we don't pass NULLs to our Procs, but are you setting the parameter to DBNull.Value? I think just plain old null (or nothing as you VB guys like to say <g>) isn't going to work.
~~Bonnie
>>>I am getting a StrongTypingException when I try to pass a NULL date into my SPROC. What is the preferred way of doing this? I know I can set the default value in the SPROC and just not pass the parm, but is there a way to specifically pass a NULL date?
>>>
>>>Thanks!
>>
>>dim myDate as Nullable(of DateTime)
>>
>>should work in VB but I'm not sure.
>>
>>Cetin
>
>So I can pass a nullable datetime variable as a parameter into my SPROC?