I WANT TO INSERT A SINGLE QUOTE IN TEXT AS "ABC'S"
INSERT INTO TABLE1 (CODE,NAME) VALUES ('A001','ABC'S')
Printable View
I WANT TO INSERT A SINGLE QUOTE IN TEXT AS "ABC'S"
INSERT INTO TABLE1 (CODE,NAME) VALUES ('A001','ABC'S')
If you just double it up then it will work.
INSERT INTO TABLE1 (CODE, NAME) VALUES ('A001', 'ABC''S')
------------
hamid khan at 3/17/01 6:59:22 AM
I WANT TO INSERT A SINGLE QUOTE IN TEXT AS "ABC'S"
INSERT INTO TABLE1 (CODE,NAME) VALUES ('A001','ABC'S')