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