Do you mean the noise stops after it warms up or when the engine is at higher RPMs? If it stops after the engine is warm you might have an exhaust leak where the exhaust manifold bolts to the head. Also, how many miles are on the car and what is its maintenance history?