Re: Multiple parameter for WHERE clause

[Chantelle Wall <cwall@MAIL.RATH.PEACHNET.EDU>]

If your panel is running an SQR use something like this:

let $unit = RUN_CNTL.business_unit

if $unit = ' ' or $unit = ''
   let $unit = '%'
else
   let $unit = RUN_CNTL.business_unit
end-if

Begin-SELECT

BUSINESS_UNIT

  FROM PS_TABLE
WHERE BUSINESS_UNIT like $unit

End-SELECT

If your panel is running a Crystal report you can use People Code behind
the field to set the value to the wild card '%'.
begin:vcard
n:Wall;Chantelle
tel;work:(706) 369-6464
x-mozilla-html:FALSE
org:University System of Georgia - OIIT;EAS
adr:;;1865 West Broad Street;Athens;Georgia;;USA
version:2.1
email;internet:cwall@mail.rath.peachnet.edu
title:Systems Analyst
fn:Chantelle D. Wall
end:vcard