I am working on Visual Web Developer 2005 (vb.net).

I have to write query in a QueryBuilder.

I have three fields:

1. NWOID (integer) Primary key

2. CustID (String)

3. CPNRef (String)

I need a query for a WHERE clause that will return if I provide any one parameter or combination of parameters or nothing.

for example:

(NWOID)

(CustID)

(CPNRef)

(NWOID, CustID)

(NWOID, CPNRef)

(CustID, CPNRef)

(NWOID, CustID, CPNRef)

(            )    nothing

Well create a stored procedure in sql server with three parameters and set defaults for two fields, now you may call that stored procedure with :

1 argument

2 arguments

3 arguments

It would work in all cases and as you wanted!