LIKE 'WC[[]R]S123456'
or
LIKE 'WC\[R]S123456' ESCAPE '\'
Should work.
More Related Contents:
- Escape a string in SQL Server so that it is safe to use in LIKE expression
- Max Nbr of Months W/ No Activity in Past 12 Months
- SQL server query to output the data shown below
- Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
- How do I generate a random number for each row in a T-SQL select?
- Select columns from result set of stored procedure
- Pass Dictionary to Stored Procedure T-SQL
- Get dates from a week number in T-SQL
- Date conversion and culture: Difference between DATE and DATETIME
- How to check if a database exists in SQL Server?
- How to remove accents and all chars a..z in sql-server?
- tsql returning a table from a function or store procedure
- How can I do something like: USE @databaseName
- Escape Character in SQL Server
- How to split string and insert values into table in SQL Server
- How to determine the field value which can not convert to (decimal, float,int) in SQL Server
- How can I get the sum of multiple datetime values?
- Use of Begin / End Blocks and the Go keyword in SQL Server?
- How do you determine what SQL Tables have an identity column programmatically
- Ampersand (&) operator in a SQL Server WHERE Clause
- Avg of float inconsistency
- how to write number to word function in sql server [closed]
- SQL Server search using like while ignoring blank spaces
- Is there an “IF EXISTS” test for a linked server?
- ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
- “If not exists” fails on SQL CE
- SQL Server stored procedure return code oddity
- Incorrect syntax near ‘)’ calling stored procedure with GETDATE
- Generate MD5 hash string with T-SQL
- Why can’t Entity Framework see my Stored Procedure’s column information?