Is it of a colonoscopy that you are talking about? I had one last year and it was by far the horrible experience that I thought it would be. They only gave me a pill to help calm me down, I was not put to sleep and It was not very painfull at all . I was back home 2 hrs afterward and was allowed to take a light diner. The preparation for the test was nastier than the test itself.
Good Luck Candybear. I 'm sending good vibes your way .
Lily