Null string causing type mismatch

[Xocitus]

I'm writing an old asp page to insert Session variables into a database to transfer them to an ASP.NET application. So I'm looping through them and using a stored procedure to insert them into the db. One them has a null string as a value and when inserting those it fails with :Microsoft VBScript runtime error '800a000d'Type mismatch I have Wrote them out to the page in the form as key=value=http://stackoverflow.com/questions/11671037/vartype and the vartype is indeed 8, a string. Here is the call:.Parameters.Append .CreateParameter("@SessionValue", adVarChar, adParamInput, 4000, Session(objItem))I would rather not convert it to an empty string when inserting. Is there a way around this?