Not sure what you mean in the 2nd to the last paragraph. I really prefer using the map function:

  sum(map(lambda s: len(s) if s.startswith('a') else 0,['abac','bced','asdasdf','lkjkl','assadf']))

The crazy sql like syntax of your C# example bugs me a lot.