Thank you all for the information and advice. My Dad's cancer has metastasized to his spine, bone marrow and they think also his brain (the presence in his brain has not yet been confirmed). His prognosis is about 6 months. The oncologist has said the Sutent drug could extend that time up to maybe a year. However I'm not convinced it would be a quality of life extension, but just a quantity of life extension.
Most of the family (including me) thinks the best option is to get him into hospice and make his final weeks/months as pleasant as possible. However he is the one who has the cancer and he is in a frame of mind right now of wanting to try anything and everything to extend his life. I can't blame him for that, I guess if I was the one who had limited time left I would want to try and get as much time as I could provided it was a quality time. However, his pain is getting increasingly more uncomfortable. They have now prescribed percocet and morphine for the pain. I want him to be comfortable, but my fear is he's just going to be in a heavily sedated state with no quality of life at all.