Wednesday, September 25, 2002 05:07 AM
Is the text in a large document in the database or what? Are the fields represented by a "single column" in the database. What is your database?
Your specification is vague.
If you are searching for attributes which may be in a text document in a database, DB2 and Oracle have Text Search extensions to their databases which cost beaucoup bucks; and the problem of solving this is not trivial.
If you have the fields represented by a value in a single column in a table, then your answer is in the SELECT statement in your SQL statement.