stored procedure problem no. 2

hi

basically what i need is a query that would allow user to find the position he needs in the table.
let's assume that table structure looks like this :

id title author year_of_publishing copies_available
-----------------------------------------------------------
1 | C++ |Stroustrup | 2001 | 45

now : i want user to be able to find this position when he enters all the parameters, but also when he enters only "title" - the query should find all the entries that have "c++" in the "title" field. what else : when he enters only authors name, i'd like the query to find all the books by Stroustrup.

basically : i'd like to know how to do a query that would take "blank" arguments as "everything"

is that possible?

any help will be appreciated

cheers.

see The "any" option in dynamic search SQL
site registration may be required, but it's free