walk into any hosptial or doctor establishment and they will have some sort of compassion for you, it is their job and should be every human beings job to have compassion. I do not know if they will give you the substance you desire, but they will help.
I agree with tired...why not go and talk with your doctor about this.
I would imagine they'd have no problem giving you some comfort meds to help you. Why not just go to your family doctor instead though?