Stored Procedures

I want to create a stored procedure in informix SPL where i dont know the WHERE clause of the select statement. As far as I could gather from the manuals ; I can only select if the where clause is known. My requirement is as follows :- I want to write a stored procedure to get all the customers based on the user input . He/she can search it based on Customer # ( char (6), Customer name ( char (40 ) or Customer State ( char(2) ). Since I dont know what will be entered by the user ; hence I want to implement QBE in the stored procedure ? Is it possible. Thanx ------------ Sanjay Kumar Email: skumar@raileurope.com Rail Europe Inc. White Plains, NY 226 Westchester Ave | Office : (914) 681 3296 White Plains NY 10604 | Fax : (914) 682 5236