TSQL Fulltext search of word containing 1 digit and 1 letter

40 Views Asked by At

Searching fulltext indexed table for word "1F"

DECLARE @name nvarchar(50) = N'"1F"'

SELECT *
FROM [mydb].[dbo].[mytable]
WHERE CONTAINS(name, @name)
bla bla F bla
results F 

Returns all records where even one separate letter "F". The "1" can be 0...9 with no difference in result. And not returns "1F"

What is wrong?

0

There are 0 best solutions below