As Kathryn said it doesn't have to be water, as long as you bladder is full that is all that matters. I can't stomach water at all atm and when I had my first u/s I drank juice and it was fine.

Good luck with your scan on Friday.