You should look into that. It's just an option on the parameter. Really easy to set and it may solve your problem. If you are calling a stored procedure and passing the parameter to it, you'll need to make that nullable too. The syntax on that is @Parameter datatype = NULL.