I'm on the process of choosing a domain name and I was wanting to ask, does the domain name in anyway add value to the site in terms of SERPS?

I'm thinking that it does, but then again I'm not sure. I asked a link builder friend of mine and he said it doesn't matter - he says that its the keywords and content which brings you SERPS.

Your thoughts then?