single quote and insert statement

• keywestfl9

  SSCertifiable

  Points: 5215

  More actions

  August 14, 2009 at 3:13 pm

  #134774

  for some reason i am unable to add the previous post of mine

  i have one more scenairo where i am using replace to null the newline. i need to take care of single quote

  insert into table1(column1) values ('" + REPLACE((DT_STR, 50, 1252) @[User::UUMtableoutput] , "", "") + "')"

• SSIS\SSRS\SSAS

  SSCertifiable

  Points: 6038

  More actions

  August 14, 2009 at 3:30 pm

  #1039733

  keywest u r confusing man..

  post some data and the reults u trying to get. and alos get into details what u trying to do....