Does soda rot your teeth?

There's an urban legend that teeth dissolve in a glass of soda. How harmful is it really?