-
How to use ' in single quotes in a update statement
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|