Parameters

  • Thread starter Thread starter Gary B
  • Start date Start date
G

Gary B

I write to write a Query that can return all rows or a specific row by
passing a parameter.

parameter custparm integer;
select * from customers
where customerkey = custparm

Of course, if I want s specific customer, I pass his customerkey,
but what can I do, or what can I pass as custparm that will return ALL rows.

Thanks!
 
select * from customers
where customerkey = Nz([Enter Customer Key or Leave Blank for
all],CustomerKey)
 
Back
Top