A select challenge or is it?

With some help from folks in this newsgroup I have solved most of my problems, I think this is the last one:)

What I want to do:

From my table select all rows that match keywords in one of six columns, i.e col1,col2.....or col6 contain keyword.

I can do this using instr and it works very well.

My problem is that the user can choose to input a number of keywords. Do i just need to write select statements for each condition (i.e 2 keywords have two instr statements in the where clause etc.)?

Is there a better way to solve this problem? Stored procedures, PL/SQL etc.

Thanks in advance.

--
æ___________________________________________________________________________
				S. Kharbanda

			wherever you go there you are
___________________________________________________________________________