Sorry, my english isn't that good!!<BR>I'm trying to input an empty value in my table, the colume is numeric, and i get this error" Error converting data type varchar to numeric"<BR>So my question could also be, how do I get an empty varchar value to become an empty numeric value?
ok better :-)<BR><BR>Now, if I understand this correctly, you are trying to make an INSERT statement but then you get an error message saying:<BR>"Error converting data type varchar to numeric"<BR><BR>This is because you are trying to INSERT a varchar INTO a numeric field. (I know you know, but I'm just pointing this out!)<BR><BR>You'll need to use Cint() to convert your varchar into a numeric value BEFORE you make your INSERT.<BR><BR>Look for Cint() or Clng()<BR><BR>If this doesn't work, please show me your SQL Query and make a Response.Write of your SQL Query<BR>