Remove single quotes from a string

• komal145

  SSCrazy Eights

  Points: 9892

  More actions

  October 4, 2018 at 12:30 pm

  #377917

  hi ,
  I have leading single quotes in a string . I tried to remove using "replace" but it is not working

  String = '00000000000

  can any one pleas help me with this?

• Joe Torre

  SSChampion

  Points: 10248

  More actions

  October 4, 2018 at 12:48 pm

  #2008186

  DECLARE @STR nvarchar(20)='''00000000000';
  SELECT @STR String, Replace(@str, '''', '') ReplacedString;