SQL Insert Query using ADO

[Tim johnson]

Hi,

I am sending an SQL Insert query to my ADO connection
object, my Insert query looks a litte like this...

INSERT INTO tblRequests
(RequestedBy,ContactPerson,RequestReason) VALUES ('Test
Person','Joe Bloggs','The main reason's are this...')

Notice that the value of the RequestReason field contains
a ' character in the word "Reason's", SQL seem to handle
this as the end of the value for that field. How can I
stop this from happening? I don't want to have to remove
all ' chars from each field value?

Help. Tia!

[Ken Schaefer]

To escape a single quote, you need to double it, so your SQL statement looks
like this:

INSERT INTO
tblRequests
(
RequestedBy
, ContactPerson
, RequestReason
)
VALUES
(
'Test Person'
, 'Joe Bloggs'
, 'The main reason''s are this...'
)

(that's two ' in a row, not a double quote)

Cheers
Ken

"Tim johnson" <timj@smithscity.co.nz> wrote in message
news:054701c366aa$d855c900$a401280a@phx.gbl...
: Hi,
:
: I am sending an SQL Insert query to my ADO connection
: object, my Insert query looks a litte like this...
:
: INSERT INTO tblRequests
: (RequestedBy,ContactPerson,RequestReason) VALUES ('Test
: Person','Joe Bloggs','The main reason's are this...')
:
: Notice that the value of the RequestReason field contains
: a ' character in the word "Reason's", SQL seem to handle
: this as the end of the value for that field. How can I
: stop this from happening? I don't want to have to remove
: all ' chars from each field value?
:
: Help. Tia!