I have create this little sample Table Person.
The Id is a primary key and is identity = True
Now when I try to create a FullText Catalog, I'm unable to search for the Id.
If I follow this wizard, I'll end up with a Catalog, where its only possible to search for a persons name. I would really like to know, how I can make it possible to do a fulltext search for both the Id and Name.
SELECT * FROM [TestDB].[dbo].[Person] WHERE FREETEXT (*, 'anders' ); SELECT * FROM [TestDB].[dbo].[Person] WHERE FREETEXT (*, '1' );
I would like them to return the same result, the first returns id = 1 name = Anders, while the second query don't return anything.
Looks like the problem is in using int, but is it not possible to trick FullText to support it?
Created a view where I convert the int to a nvarchar.
CONVERT(nvarchar(50), Id) AS PersonId this did make it possible for me to select that column, when creating the Full Text Catalog, but It still won't let me find it searching for the Id.