Hi Keith

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..

WHERE

(DATEDIFF(DD, Client.EffDate, Client.Expdate) IS NULL) OR

(DATEDIFF(DD, Client.EffDate, Client.Expdate) > 0)

and

case

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..

Thanks Again