Hi there,

you can use replace function which has following syntax

-: replace(@stringvar,charactertoreplace,newcharacter)

for e.g.

DECLARE @HashText nvarchar(10)

set @HashText= '''1,2,3,4'''

declare @grate nvarchar(10)

set @grate=replace(@HashText,'''','')

select @grate