Invalid character value for cast specification

• Carl Farmer

  SSCrazy

  Points: 2197

  More actions

  November 30, 2004 at 10:25 am

  #84938

  I have an SP that used to work before, returned rows no problem. I have since altered the SP and started getting the below error. The change I made basically took one of the input params, concatenated the @@ROWCOUNT value, converted it all to VARCHAR variable and then passed the final variable into the xp_SendMail XP on another server. I have since removed the changes and am getting the same error.... any ideas?

  [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification

  (MAPI profile will be added to the server at a later date)

  Thanks in advance.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  November 30, 2004 at 11:04 am

  #531918

  can u send the code where the line accurs.. this doesn't help me much to pinpoint the problem.

• hoo-t

  SSChampion

  Points: 12713

  More actions

  November 30, 2004 at 12:33 pm

  #531937

  Its a "typematch error".  Basically, you're trying to load a non-numeric character into a numeric field, or a non-date value into a datetime field.

  Steve