'How do I escape parenthesis within a CONTAINS using T-SQL?

I want to have the following query:

SELECT COUNT(*) FROM MyTable WHERE
CONTAINS (MyField, '(429)')

The problem, is that the parenthesis are ignored and it is finding anything with "429". I just want "(429)" found. If I change it to have '"(429)"' that does not help (it still returns items with just "429").

tsqlescapingcontains


Solution 1:[1]

Maybe you should explicitly convert (429) to a varchar.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a16434f3-5b94-44a1-a8cf-d66f832e1195/convert-integer-to-string

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Lane Goolsby

Related Questions

Return a value if no rows are found in Microsoft tSQL

Return a value if no rows are found in Microsoft tSQL

Return a value if no rows are found in Microsoft tSQL

Getting maximum value of float in SQL programmatically

Getting maximum value of float in SQL programmatically

Getting maximum value of float in SQL programmatically

Getting maximum value of float in SQL programmatically

Conversion failed when converting date from character string

How do I create a SQL Function to return a BIT?

CONCAT_WS() for SQL Server

Export database schema into XML file

SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

Using a SELECT statement to return a row where a DateTime column = variable of type Date?

Is it necessary to test for NULL if also testing for greater than?

SSMS 2012: Convert DATETIME to Excel serial number