troubleshooting Question

insert query with value having 's

Avatar of RIAS
RIASFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008
2 Comments1 Solution154 ViewsLast Modified:

i am trying to insert

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

Any suggestions?
Haris Dulic
Just an IT guy :)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros