Replace single quotes in SQL Server July 10, 2023 by Tarik You need to double up your single quotes as follows: REPLACE(@strip, '''', '')