• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 97
  • Last Modified:

insert query with value having 's

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?
0
RIAS
Asked:
RIAS
1 Solution
 
Haris DjulicCommented:
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

0
 
RIASAuthor Commented:
Cheers!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now