Make a UDF like this:-CREATE FUNCTION dbo.ReverseValues@ValueList varchar(8000),@Delimiter char(1)RETURNS varchar(8000)ASBEGINDECLARE @String varchar(100),@Final varchar(8000)WHILE @ValueList IS NOT NULLBEGINSELECT @String=CASE WHEN CHARINDEX(@Delimiter,@ValueList)>0 THEN LEFT(@ValueList,CHARINDEX(@Delimiter,@ValueList)-1) ELSE @ValueList END, @ValueList= CASE WHEN CHARINDEX(@Delimiter,@ValueList)>0 THEN SUBSTRING(@ValueList,CHARINDEX(@Delimiter,@ValueList)+1,LEN(@ValueList)) ELSE NULL ENDSET @Final=@String+ COALESCE('/'+ @Final,'')ENDRETURN @FinalEND
then try like thisUPDATE YourTableSET yourCol=dbo.ReverseValues(YourCol,'/')