Thanks for the URL.

I've noticed that the CONTAINS and FREETEXT functions seem to be where I need to be. I'm new to FTS stuff myself, therefore it's all greek...

I figured it out....must have PK on table and when dropped/recreated, the PK didn't get re-created.

Thanks,

Dave

Well, just when I thought the nightmare was over I discovered that it isn't....

At this point we have the following work arounds. We have one for each of the...

Guys,

Thanks again for the help. I finally have a workaround. Now I just have to figure out how to plug it back into the original query.

...PITA is an...

Sorry guys.... I should have posted the expected result set a long, long time ago. BEFORE I GO ANY FARTHER, THANK YOU THANK YOU THANK YOU FOR THE ANSWERS/REPLIES...

Ok...still struggling on this one....

I follow the example you gave, but I should have provided more relevant test data in my original post. I can't seem to...