Joe,
Yes, there is... that is, IF you're using SQL Server 2000...
If so, check out Full-Text Search (FTS) in SQL Server 2000 Books Online
(BOL) titles "Filtering Supported File Types" and "Column-Level Linguistic
Analysis" for more information on searching the text in the blobs or the
IMAGE datatype.

Regards,
John
PS: Note, you can also post FTS related questions to the newsgroup:
microsoft.public.sqlserver.fulltext



[quoted text, click to view]

I'm new to this SQL stuff

i have a SQL DB that has MS Word documents stored in OLE blobs. is there
any way to search the text in blobs? Any advice is appreciated

thanks
Joe