insert query with value having 's

RIAS
RIAS used Ask the Experts™
on
Hello,

i am trying to insert

      INSERT INTO  [CORRCE] (  [Year_Ref] ,  [Ref]  ,[Date] ,[SentTo] )      
     
      
         VALUES
       ('22' , '556' , '21 September 2016' , ' hotel 's b'a')

Any suggestions?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Architect
Commented:
Hi,

try this :

INSERT INTO  [CORRCE] (  [Year_Ref] ,  [Ref]  ,[Date] ,[SentTo] )         
VALUES
('22' , '556' , '21 September 2016' , ' hotel ''s b''a'')

Open in new window

Author

Commented:
Cheers!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial