If you are storing in a garbage dump (table with lots of text,
non-separated), your best option is using a full text index to index the
comma separated keywords. Personally, I would consider a less taxing
database structure, like one that enumerates the keywords, but that is just
my feeling on this type of data. It may not be feasible in your situation.
Regardless of your choice, the user's list of keywords presents you with
options:
1. Write the SQL in your app and submit to the database
2. Turn the keyword list into XML and use the XML capabilities of the
database (both Oracle and SQL Server can use this option)
3. Create a stored procedure that puts the user list in a temp table and
join that table with the tables being queried
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** **
Think outside the box!
*************** *************** *************** **
"huzz" <hu**@discussio ns.microsoft.co m> wrote in message
news:57******** *************** ***********@mic rosoft.com...
I've a table filed holds keywords seperated by comma, and a web search
form
where a user can type one of multiple keywords in the search text field
seperated by comma aswell. How do i create a sql statement to bring
results
that matches one or more keywords in the database?
Many thanks in advance..
huzz