Just a follow up. My problem was with the 2005 Noise Word files. Found the file, dropped the A-Z portion, rebuilt index and viola works like a charm.... thanks for everyone advice etc... ___________________ Eric Jones aka jonese http://www.jonese.us http://twitter.com/jonese
On Fri, Jan 23, 2009 at 3:04 PM, jonese <gig...@gmail.com> wrote: > I have two columns authorForeNAme and authorLastName and i'm trying to > search against a Full Text index to find a specific author. > i thought i could do this: > > SELECT * > FROM author > WHERE CONTAINS(authorForeName, N'"B"') AND CONTAINS(authorLastName, > N'"LYNE"') > > But it returns zero records. however if i do > > select * > from author > WHERE authorForeName = 'B'' AND CONTAINS(authorLastName, N'"LYNE"') > > I get my desired results. > > Why doesn't the first query work as expected? > ___________________ > Eric Jones aka jonese > http://www.jonese.us > http://twitter.com/jonese >