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 ...