Program to insert a single quote in the varchar text in SQL Server

Rajnilari2015
Posted by Rajnilari2015 under Sql Server category on | Points: 40 | Views : 940
The below program will do so

declare @tbl table(SomeField varchar(50))
insert into @tbl(SomeField) values('He is one of the leader''s')
select * from @tbl


Result
---------

SomeField 
He is one of the leader's

Comments or Responses

Login to post response