I am doing a full text search for a document called "Document 1". The following sql does not return the record. However, if I change the 1 to a 10, it returns "Document 10" select * from document_keyword where CONTAINS (keyword,'Document AND 1')
Oh...I forgot that single characters such as a,A,1,2 are considered to be noise/stop words and are left out of the full-text index since they are empirically known to be useless to a search. So may be, you have to revisit your stop words to make it work. Hope it helps.