Has anyone had their teeth professionally whitened at the dentist's office?

I'd like to have my teeth professionally whitened in the next year. I'm wondering if anyone has had good results and what the cost was?

I have heard that the Zoom technique works but is really painful. I have heard the Brite Smile system also works but is less painful.

I'd love to hear any stories before making a decision!

Thanks!