Special Characters in INSERT Statement

[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:

23302220202XXXXXXXXXXXXXXXXXXXXXXXXX

Where "X" represents the ascii character 0.

INSERT INTO MyTable (ThisNumber) VALUES
('23302220202XXXXXXXXXXXXXXXXXXXXXXXXX')

...Creates the syntax error.


Any help would be appreciated.

Lee Jenkins