you might want to look at a third party solution try http://www.isysdev.com
we used one of their cd based solutions a while ago & searching 30+mb of text by keyword was very speedy - it brought up the search results before i even started typing ;-) steve ----- Original Message ----- From: "Scott Barnes" <[EMAIL PROTECTED]> Newsgroups: cfaussie To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, March 12, 2003 11:23 AM Subject: [cfaussie] SQL text vs varchar | Hey | | If you have a scenario where you have a large quanity of text, inside a | table thats 8000 chars+ what is the optimal way in searching that text filed | without using LIKE '%keyword%' | | ScottaSan | | | | --- | You are currently subscribed to cfaussie as: [EMAIL PROTECTED] | To unsubscribe send a blank email to [EMAIL PROTECTED] | | MX Downunder AsiaPac DevCon - http://mxdu.com/ | --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
