• where @parameter = 'All'

    or (@parameter = 'GT30' and updated_date < getdate() - 30)

    or (@parameter = 'LT30' and updated_date between getdate()-30 and getdate()) ;

    Tom