Search Facilities-Please Suggest
-
Hi All, I have to make search routine which can search against each field of the table, and user can search with these option example, there is a field Name in the table, user can select from combo "Equal","Contains","Starts With","End With" then type something in the text box, system willl search according. I am thinking to use freetext search facilities of SQL server 2005, please confirm , can we implement search like explained above using freetext search. if yes please suggest me an article, other option is obviously is like query. Second Question and one more thing, each record will have a pdf document, i m intended to store these doc into the database, and give search facilitess against them as well, please suggest from where i have to start to store pdf doc in binary, and give search facilites against the docs. Please take in cosideration , that there is thousands of records in each table.and document size can be upto 50MB. Any help will be highly appreciated. Many Thanks & Best Regards, Adnan
Many Thanks, Adnan Rafiq muhammadadnanrafiq@gmail.com