I've had most of my friends since middle school, way before we ever started drinking. They all know my deal nowadays and support it, they aren't gonna quit drinking though. I've been around them when they are drinking, to be honest hasn't bothered me. We usually just hang out and watch tv/sports/movies/played games anyways, drinking isn't always involved either. If they were to go out to the bar or have a party or just around outside and drink I wouldn't bother joining them though, nothing for me to do.
I would not want to go through life with no friends, so I'd just do what I would have to do to make some new ones.