Can we see your code?
____________________________ Jeff Seger Fairchild Semiconductor [EMAIL PROTECTED] ____________________________ "Tim Johnson" <[EMAIL PROTECTED]> 04/15/2004 01:35 PM To: <[EMAIL PROTECTED]>, "Dbi-Users" <[EMAIL PROTECTED]> cc: Subject: RE: Invalid character value for cast specification No, but I tried taking away the placeholders and moving my variables into my prepare statement, and this is what I got: "Line 1: Incorrect syntax near 'Disty'." Here is the field in question: 'Enhancement- Load Disty Accounts into Production (Joe Bloe)' -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 10:26 AM To: Tim Johnson Subject: RE: Invalid character value for cast specification Does this row contain an Irish name like O'Donnel? -- Charles Knell [EMAIL PROTECTED] - email -----Original Message----- From: Tim Johnson <[EMAIL PROTECTED]> Sent: Thu, 15 Apr 2004 09:57:48 -0700 To: "Dbi-Users" <[EMAIL PROTECTED]> Subject: Invalid character value for cast specification I keep getting this error when I try to insert rows into my SQL Server 2000 DB. Is there any way to find out which character is causing the problem? I have a feeling I'm doing something stupid, but I'm trying to figure out what, and I think if I knew which character it was I would know.