SQL Server Escape an Underscore

by

T-SQL Reference for LIKE:

You can use the wildcard pattern matching characters as literal characters. To use a wildcard character as a literal character, enclose the wildcard character in brackets. The following table shows several examples of using the LIKE keyword and the [ ] wildcard characters.

For your case:

... LIKE '%[_]d'

More Related Contents:

  1. How to multiply column in Sql
  2. What is the best way to create and populate a numbers table?
  3. Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?
  4. How do you clear the SQL Server transaction log?
  5. Order Of Execution of the SQL query
  6. SQL Server IN vs. EXISTS Performance
  7. How Can I Log and Find the Most Expensive Queries?
  8. XML Server XML performance optimization
  9. How to do version control for SQL Server database?
  10. Connecting to SQL Server LocalDB using JDBC
  11. How to check if a database exists in SQL Server?
  12. BULK INSERT with identity (auto-increment) column
  13. determining the character set of a table / database?
  14. error when inserting into table having instead of trigger from entity data framework
  15. How to query values from xml nodes?
  16. How to split string and insert values into table in SQL Server
  17. Case sensitive variables in SQL Server
  18. How to query for Xml values and attributes from table in SQL Server?
  19. Full text search does not work if stop word is included even though stop word list is empty
  20. Should I index a bit field in SQL Server?
  21. Setting up maven dependency for SQL Server
  22. Getting a warning when using a pyodbc Connection object with pandas
  23. Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
  24. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  25. How can I get the list of tables in the stored procedure?
  26. Escaping single quote in SQL Server
  27. How to find the boundaries of groups of contiguous sequential numbers?
  28. Conditional JOIN Statement SQL Server
  29. How do you deal with blank spaces in column names in SQL Server?
  30. ODBC Call Failed with stored procedure – Pass through query

Leave a Comment