Problem with simple insert | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problem with simple insert

I have a hard time figuring out this simple insert with (‘) on the character. How can i do that without modifying the data? I tried using [] and concat but it doesn’t give me the correct format.
create table #t(
id int identity(1,1)
, description varchar(256)) insert into #t(description)
values (‘Service Member’s Opportunity College’)
select * from #t
drop table #t
Thanks,
DilliGrg
Just add another single quote to it… create table #t(id int identity(1,1), description varchar(256))
insert into #t(description)values (‘Service Member”s Opportunity College’)
select * from #t
drop table #t Mohammed.
quote:Originally posted by DilliGrg I have a hard time figuring out this simple insert with (‘) on the character. How can i do that without modifying the data? I tried using [] and concat but it doesn’t give me the correct format.
create table #t(
id int identity(1,1)
, description varchar(256)) insert into #t(description)
values (‘Service Member’s Opportunity College’)
select * from #t
drop table #t
Thanks,
DilliGrg

Got it, never mind. create table #t(
id int identity(1,1)
, description varchar(256)) insert into #t(description)
values (‘Service Member”s Opportunity College’)
select * from #t
drop table #t Oops, didn’t realize that MohammedU had already replied. Thanks,
DilliGrg
quote:Originally posted by MohammedU Just add another single quote to it… create table #t(id int identity(1,1), description varchar(256))
insert into #t(description)values (‘Service Member”s Opportunity College’)
select * from #t
drop table #t Mohammed.

Thanks for your reply. Thanks,
DilliGrg
]]>