Removing Quotes From String
You are using 6 quotes, this is not correct, you are trying to replace every single quote ', then use only a double quote '' to indicate the string pattern.

If you use '''' four quotes you are really searching for a double ''

REPLACE(@Param1, '''', '')