question

What happens if you try

select * 
    from document_keyword 
    where CONTAINS (keyword,'"Document 1"');

? The problem in your original query could be caused by the fact that the term **1** is too short (only one character in length).

Well, the returns all that have the keyword 'document'. Looks like it ignores the 1 altogether RESULTS: Document 1 Document 2 Document 3 Document 10 Document 11 Document Description If I change to select * from document_keyword where CONTAINS (keyword,'"Document 10"'), it just returns the one row where keyword = Document10

If I follow the proper **AND** operator syntax. It should have been like this select * from document_keyword where CONTAINS (keyword,' "Document" AND "1" ') The two contains search conditions must be double quoted. But I guess that would not give any result too. This is where I agree with @Oleg that CONTAINS can search for a word or a phrase, but for a single character it may not be performing as desired.