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

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


He is one of the leader's

Comments or Responses

Login to post response