'How to perform Full Text Search containing numeric data on varchar field?

I am using Full text search to search '6(1)c' with type varchar. How can I fetch the rows containing the above pattern using Full Text Search in Sql server.

I am using the following query.

Select * from table1 where contains(*,'6(1)')

sql-serverbackend


Solution 1:[1]

Full Text search is directed toward "words" (of a particular spoken language), see CONTAINS.

If seeking a string such a 6(1)c I suggest you would be better off trying LIKE e.g.

select * from table1 where col1 LIKE '%6(1)c%'

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 Paul Maxwell

Related Questions