On 8 Apr 2003 at 20:10, Alexander Tabakov wrote:

>I want to retrieve all of the addresses at Street_Name = xxxxxxxx,
>etc. Search criteria must support not fully qualified addresses;

Then, you have to generate query text at run-time and put only
mentioned fields into WHERE.

SY, Dimitry Sibiryakov.