title: Stored Procedure Parameters - sometimes NULL
body: <p>i have a stored procedure to update a table. not all fields are required and some can be blank.</p>
  
  <p>for example, title is not required, but when it's blank i get an error</p>
  
  <pre><code>          Dim ptitle As New SqlParameter("@title", SqlDbType.NVarChar, 20)
      ptitle.Value = objFormat.CheckSQL(title)
      myCommand.Parameters.Add(ptitle)
  </code></pre>
  
  <ul>
  <li>ex {"Procedure or Function 'sp_UpdateUser' expects parameter '@title', which was not supplied."} System.Exception</li>
  </ul>
  
  <p>how can i fix it so that it allows for nulls if the data field is blank?</p>