I had it done about 8 years ago at Bangkok Hospital in Korat, cost just over 10,000 baht. No medication only a sedative, awake all the time, no pain whatsoever and watched it on a big tv screen with the doctor explaining to me the infected areas of my colon. No waiting around only to empty my bowels after having to drink a litre of liquid they gave me, never saw another patient and was in and out the hospital in less than 4 hours.