Escape Character

KevinYC · #1 (**permalink**) 09-16-08, 17:28

Hello,

How would I use escape character in this case?
I replaced the two 's inside the quotes with " and it didnt work.
Any suggestions?

UPDATE TB939
SET COMMENT2 =
'of Cap1's and Dr. Head's handling of the case.'
WHERE EID = '0000086807';

Thank you for any input

n_i · #2 (**permalink**) 09-16-08, 22:21

Double the single quote:

Code:

'of Cap1''s and Dr. Head''s handling of the case.'

Note that what's highlighted are two single quotes, not one double quote.

KevinYC · #3 (**permalink**) 09-17-08, 09:04

Quote:

Originally Posted by n_i

Double the single quote:

Code:

'of Cap1''s and Dr. Head''s handling of the case.'

Note that what's highlighted are two single quotes, not one double quote.

Thank you n_i

Internet Services

Web Development

Digital Marketing

Consumer Tech