Set Full Text Search to treat Numbers at Text Sql Server 2008 R2
Posted on 2014-09-02
I am testing setting up a Full Text Search and I am having issues when trying to search for a Numbers.
If I search for contains(ColumnA,'"5"')
It will only return rows that have "5"
It won't return rows that contain "5mm" or "5Ltr"
Can I make it treat all Numbers as Text?
Also if I search for contains(ColumnA,'"2.5m"')
It will return results that contain "2.5m" AND results that contain "25m" (It searches for the decimal point then drops it and joins the "2" and the "5m" together)