How do I escape a percentage sign in T-SQL?

by

Use brackets. So to look for 75%

WHERE MyCol LIKE '%75[%]%'

This is simpler than ESCAPE and common to most RDBMSes.

More Related Contents:

  1. SQL Server – error when creating stored procedure
  2. How can foreign key constraints be temporarily disabled using T-SQL?
  3. Pad a string with leading zeros so it’s 3 characters long in SQL Server 2008
  4. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  5. SQL Server String or binary data would be truncated
  6. Datatype for storing ip address in SQL Server
  7. How to change identity column values programmatically?
  8. SQL Server Regular expressions in T-SQL
  9. Is there a way to loop through a table variable in TSQL without using a cursor?
  10. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  11. How do I format a number with commas in T-SQL?
  12. Concatenating Column Values into a Comma-Separated List
  13. How to set a default value for an existing column
  14. Need a datetime column in SQL Server that automatically updates when the record is modified
  15. SQL Server: combining multiple rows into one row
  16. How do I find a stored procedure containing ?
  17. Query to list all stored procedures
  18. SQL Server: Index columns used in like?
  19. SQL Server – Auto-incrementation that allows UPDATE statements
  20. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  21. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  22. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  23. FOR XML PATH(”): Escaping “special” characters
  24. Cannot bulk load. Operating system error code 5 (Access is denied.)
  25. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  26. Does query plan optimizer works well with joined/filtered table-valued functions?
  27. comma delimited list as a single string, T-SQL [duplicate]
  28. SQL Server error “Implicit conversion of because the collation of the value is unresolved due to a collation conflict.”
  29. INSERT INTO @TABLE EXEC @query with SQL Server 2000
  30. Cannot delete rows from a temporal history table

Leave a Comment