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'
Forum Rules