Cool, this was more or less just a preformance (which would you do in this situation) question. Thanks for the responses :)
On Thu, 3 Mar 2005 13:09:26 -0500, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > one word...Verity :) > > DK > > > On Thu, 3 Mar 2005 11:54:38 -0600, Greg Morphis <[EMAIL PROTECTED]> wrote: > > Quick question... > > I'm wanting to do a keyword search would be it best to > > A. have one huge text field (varchar2 or clob) and search using like > > '%keyword%' > > or > > B. set up the database where these search-a-ble words are each a row > > themselves.. with an ID. > > So you'd have 50+ fields with each searchable word or phrase has it's own > > row? > > This is more of a preformance question.. > > > > -- > > Auxilium meum a Domino > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197304 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54