reports v3.0 query

From: <janakah_at_hotmail.com>
Date: Wed, 17 Feb 1999 06:51:46 GMT
Message-ID: <7adou0$alv$1@nnrp1.dejanews.com>

Hi,

I am creating a simple report with number of parameters. If the user leaves any one of parameter empty I want to select all records. In my quey p_...denotes parameters. So my query is like select field names from table_name where title like nvl(:p_title,title) and phone like nvl(:p_phone,phone) .... My problem is if any one of these fields contain a null value then the whole record is not selected. Can anyone please tell me how to get around this problem.

TIA -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 17 1999 - 00:51:46 CST