Hi Folks, I'm hoping that someone will be able to point me in the right direction. I have created several lists to distribute email to user groups. These emails are stored in a MS SQL database. I want to be able to query the mail table and do wild card searches on message_body column and for emails that satisfy the search I want to show those emails on a web page. So I want to be able to do something like this:
SELECT * FROM mail WHERE UPPER(message_body) LIKE '%TEST STRING%' ORDER BY last_updated DESC This should return all the content from the emails so that they can be displayed on a web page. Any help would be much appreciated.... Thanks in advance, Stephen --------------------------------------------------------------------------- This e-mail message (including attachments, if any) is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, proprietary , confidential and exempt from disclosure. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender and erase this e-mail message immediately. --------------------------------------------------------------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
