How to use ' in single quotes in a update statement

[gary]

Hello, everyone,

I have a problem to update one record to put a ' into a single quotes in a update statement.

For example, update emp set last_name='john's' where id_no=2305;

I got the error message of "not properly terminated";

Could someone tell me how to put the ' into the single quotes in a update statement?

Thanks a lot in advance.

Gary

[LKBrwn_DBA]

Try:

update emp set last_name='john''s' where id_no=2305;

(Two single quotes together).