Lavender -
I've had several endoscopies, and have had no problem. They usually give you a very mild sedative through an IV...you're not exactly out, but you don't remember a thing when you wake up in recovery! And, I've never even had a sore throat afterwards. My take on this is that it's a piece of cake...getting the IV in is the hardest part and that's not even too bad.
It's the best test for figuring out if the hurt is coming from acid reflux or gastritis, which must be what your doctor suspects if he/she wants to do an endoscopy.
If you have more specific questions, put another note on the board and I'll try to answer it. Also, have you been scheduled yet? If so, when?
Ruth