Replace single quotes in SQL Server

by

You need to double up your single quotes as follows:

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

More Related Contents:

  1. Do I really need to use “SET XACT_ABORT ON”?
  2. SQL Server stored procedure return code oddity
  3. Max Nbr of Months W/ No Activity in Past 12 Months
  4. Export from SQL Server to Excel
  5. SQL server query to output the data shown below
  6. hide/remove header and footer
  7. How to use a variable for the database name in T-SQL?
  8. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  9. SQL Server: SELECT only the rows with MAX(DATE)
  10. Floor a date in SQL server
  11. Create a view with ORDER BY clause
  12. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  13. INSERT INTO vs SELECT INTO
  14. Possible to store value of one select column and use it for the next one?
  15. LEN function not including trailing spaces in SQL Server
  16. How to view transaction logs in SQL Server 2008 [closed]
  17. Scheduled run of stored procedure on SQL server
  18. SQL Server ORDER BY date and nulls last
  19. SSRS 2014 report deploy issue
  20. Best way to implement an audit trail in SQL Server?
  21. How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  22. SqlDataAdapter.Fill method slow
  23. How can I Insert data into SQL Server using VBNet
  24. What happens to the primary key Id when it goes over the limit?
  25. how to write number to word function in sql server [closed]
  26. Milliseconds wrong when converting from XML to SQL Server datetime
  27. Using GROUP BY with FIRST_VALUE and LAST_VALUE
  28. Table Valued Function Killing My Query Performance
  29. Pivot multiple columns based on one column in SQL Server
  30. How to do Sql Server CE table update from another table

Leave a Comment