How big are stars in comparison to the Earth?

Emma Monkey asked: If you can see stars that are billions of light years away, then I figure they must be huge up close, but on Sc-Fi programmes like Star Trek they still look the same size as they do from Earth. So can you please tell me how big are they really?