How to insert null into an SQL string : <p>In C# code, I have a string that has been concatenated together to build an SQL insert statement, and that is then passed into a stored procedure and run.
The problem is that I have a field in the concatenated string, call it Salary, that is a numeric in the database. However, as it's being built in the C# code, its obviously a string. There's an error in the SP when it comes time to insert, <code>Error converting data type varchar to numeric</code>. The big insert string that is created is run in the SP all at once, so I can't check individual values in the SP. And I can't make Salary = the string null, because that just inserts the string "null" rather than a null value.</p>
