In our SQL Server database, there's a table called tblCampaign. In this table, one field is called ClientCode, which is Numeric(5) data type. In my ASP page, I call stored procedure to add a new campaign. The value of ClientCode is requested from a text box (this means the value is string). So I need to convert the string type to a numeric type so that it can match the data type defined in stored procedure. But when I use either CLng, CDbl, CInt, I got a same message : "Type mismatch". I tried CDec, but it's not supported by ASP. What should I use for this situation? If any one knows the answer, please help me. I really appreciate your time.