>That's what I ended up having to do. Thanks for the input!Better late than never, I always say. <g>
~~Bonnie
>
>>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?