declare @SQL VARCHAR(MAX) = 'String to Replace' set @SQL = REPLACE(@SQL, ')', 'Replacement String') select @SQL