Insert a string with different characters

• sreeya

  SSC Eights!

  Points: 979

  More actions

  May 20, 2010 at 9:36 am

  #96811

  Hi,

  I need to insert a string ('DA'='T*') into a row under one of the columns in a table. Since it has different characters in it, how to insert it ? Thanks in advance

• Wesley Norton

  SSCrazy

  Points: 2827

  More actions

  May 20, 2010 at 3:41 pm

  #1170477

  How about this?

  if object_id('tempdb..#chartemp')is not null drop table #chartemp

  create table #chartemp(

  charcol nvarchar(15) )

  insert into #chartemp

  values ('''DA''=''T*''')

  select charcol from #chartemp