Thanks for getting back..
Sorry I'm a bit confused, but I think it may be better to insert it in a where in the query?
Thinking of something like..
(DATEDIFF(DD, Client.EffDate, Client.Expdate) IS NULL) OR
(DATEDIFF(DD, Client.EffDate, Client.Expdate) > 0)
when @location <>'All' then @location = location.code end
Really not sure of the last part?
I dont want to limit any location if 'ALL' is chosen..