How to construct a full-text search predicate for SQL Server 2008 -
i want search full-text column following 2 terms: 2011 j vineyards where construct predicate as "2011*" , "j vineyards*" no rows returned. a record should match is 2011 j vineyards viognier alexander valley united states after experimentation, seems related single "j" character. edit: here select statement full-text column beveragesearchdata. declare @test nvarchar(100); set @test='""2011*" , "j vineyards*"'; select * bv_beverage contains (beveragesearchdata,@test) there couple of possibilities going on here. full query , not predicate better answer. one thing going on sql full-text search eliminates single characters (as in j) when building index. if using contains , may need change noise file , restart sql server fulltext search service. if using like , may able try adding additional single character wildcard. play , see if works without 2011 , add in. where mycolumn 'j_vineyards%' mycolumn ...