Replace single quotes in SQL Server

You need to double up your single quotes as follows:

REPLACE(@strip, '''', '')

Try REPLACE(@strip,'''','')

SQL uses two quotes to represent one in a string.