Special Characters in INSERT Statement

2001-03-23 Thread Lee Jenkins
I apologize because I know I've seen this somewhere on the list before (should have saved it). I'm trying to insert some data into CHAR fields that have trailing Ascii 0 characters, but get a syntax error. The data would like this: 23302220202X Where "X" represents

Re: Special Characters in INSERT Statement

2001-03-23 Thread Paul DuBois
At 5:30 PM -0500 3/23/01, Lee Jenkins wrote: I apologize because I know I've seen this somewhere on the list before (should have saved it). I'm trying to insert some data into CHAR fields that have trailing Ascii 0 characters, but get a syntax error. The data would like this: