How to find email address format in stored binary files via indexing..

[korathualex]

How to find email address format(@) in word or pdf files stored as binary file via indexing in sql server 2008...I am able to retrieve files with keyword search using sql where contains query,...How to find email address format in stored binary files via indexing..

How to find email address format(@) in word or pdf files stored as binary file via indexing in sql server 2008.

The question you ask doesn't make sense.

I mean you want find @ Character in the database or search for the files that has @ Character in it?

This link is to search for @ Character in the database:

http://msdn.microsoft.com/en-us/library/ms179899%28v=sql.100%29.aspx

This link is to search for index files that contain @ Character in it:

http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/

[korathualex]

I want to get @ formats in inserted binary files via sql query...None was seen in above links..Please provide a solution at the earliest...