How can I escape square brackets in a LIKE clause?
LIKE 'WC[[]R]S123456'
or
LIKE 'WC\[R]S123456' ESCAPE '\'
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2020
(96)
-
▼
November
(23)
- What is Azure Active Directory? A Complete Overview
- How to create a Folder using a SQL Query?
- Export Documents saved as Blob / Binary from SQL S...
- HOW TO INCREASE THE MS SQL REMOTE QUERY TIMEOUT?
- How can I escape square brackets in a LIKE clause?
- New Lines with PowerShell
- CODING / LINUX / WINDOWS How to find and list zero...
- SQL SERVER – Find Currently Running Query – T-SQL
- SQL SERVER – 2008 – 2005 – Find Longest Running Qu...
- WAITFOR (Transact-SQL)
- how can I Update top 100 records in sql server
- Start a new line of text inside a cell in Excel
- What’s the difference between AD vs Azure AD?
- Why does my Windows Service keep forgetting its pa...
- how to set windows service username and password t...
- How to echo print statements while executing a sql...
- EXPLAIN EXTENDED
- How do you debug MySQL stored procedures?
- Performing Phrase Searches with a FULLTEXT Index
- How to output MySQL query results in CSV format?
- MySQL LAST_INSERT_ID() Function
- Send SMTP email using System.Net.Mail via Exchange...
- Regex: ignore case sensitivity
-
▼
November
(23)
No comments:
Post a Comment
Note: only a member of this blog may post a comment.