Create a full-text index and use CONTAINS to search the contents of a binary file. However, you'll need to have a separate column that contains the file type (e.g, doc, ppt, pdf, txt, etc.) of the binary document.

This column is specified when creating the full-text index. It is used by the full-text indexer to determine which iFilter to load in order to "read" through the binary and tokenize the terms (words) found in it.

See post 768830 for a set of links that will get you started with full-text.

http://www.sqlservercentral.com/Forums/FindPost768830.aspx