Subject How to use a an integer parameter to fetch parameter = "N" or all rows.
Author mlq97
How can I easily query an integer column to get the rows matching
an integer or also allow all rows to be fetched? EG:

Item.Project (integer)
Item.Location (integer)

(Case 1)
Select * from Item where
Project = :ProjectID and Location = LocationID

(Case 2)
Select * from Item where
Project = :ProjectID and Location = all locations

Thanks
Mitch