If you wanted to ask "how does he sleep?" you would say "hvordan sover han?"
Hvor is 'how' in the context of saying something like, "How strange!" ("Hvor mærkeligt!"), and never, I believe, as a question (though I'm sure someone here will disabuse me of that notion :).