When the person was suffering, I usually say 'they are at peace' but a 'my condolences to your family' is usually acceptable, either way. Offering of support like in Christina's post is always nice.