Anne, it so depends on the individual people in the church, and probably also on the denomination of it. My niece is a Methodist Pastor, and one of my strongest supporters. She used my case for a ceremony on a Sunday, to tech understanding and tolerance to her parish, and to tell them that all of us the children of God, and that he loves all of us.
You might be lucky, and have an understanding pastor as my niece is one, one never knows?