Good on ya for going Chad. None of us like that duty, but I suppose it's part of life. It's usually a matter of something like "I'm sorry for your loss" & "call me if I can do anything to help" are plenty in the way of what do I say? There isn't much more anyone can say, and like others have posted even though those in mourning may have heard the one or two sentences 100 times before you said them, it's about being there that matters.
A little off topic story I learned the hard way. My wife's mother's sister's wake was held on a day when it was 100 in the shade with around 90% humidity. I figured what harm in wearing a clean pair of dress shorts? A few other attendees also wore shorts. Mother in law, in her mid 70s, felt deeply disrespected by the shorts folk. My ignorance cost her some hard feelings. Oops. I've been coat & tie & pants to funerals guy ever since. I'm not suggesting you're going to wear shorts, I'm just yappin about it.