where @searchPhraseis currently an NVARCHAR(1000) and holds the result of a function call that puts together the full search phrase. This all works fine as is but a long search string will increase ...
We have a full-text catalog on a SQL 2000 SP4 box (Windows 2000) that contains a big list of groceries. When I search for "1%" using CONTAINSTABLE, I only get results that match "1". Is there anyway ...