<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Thanks Ken, that is a good tip I certainly can use sometime. I will see if I can work it in here. <BR>
<BR>
What I'm dealing with is 8 variables that the user can put values into. For each field that is not null I take the value and create "and city like :input1" to append to my exisiting where clause. They are not exclusive. <BR>
I'm trying to avoid building a gigantic Case statement which is what I think using Darren's approach would require. His logoc has a very simple append to the declared SQL (::and_where_clause) but in the find procedure you then load the sql open statement as follows<BR>
sql open xyz and_where_clause(and city like :input1)<BR>
<BR>
I'm sort of hoping I can load up a temp input99 with inputs 1-8 and just do sql open xyz and_where_clause(:input99)<BR>
I'm trying several things today, will let the list know if I get them to work.<BR>
<BR>
I've never built a search screen with Quick before so new territory even though I'm a 20 year PH vet.<BR>
<BR>
Karen <BR><BR>
> I am not sure exactly what you are trying to achieve, but I have a screen<BR>> were the user can change the way in which records are retrieved. I use a<BR>> UNION ALL with a temporary variable to make this work.<BR>> <BR>> Maybe this would work in your case.<BR>> <BR>> Ken<BR><BR><br /><hr />Stay up to date on your PC, the Web, and your mobile phone with Windows Live. <a href='http://clk.atdmt.com/MRT/go/msnnkwxp1020093185mrt/direct/01/' target='_new'>See Now</a></body>
</html>