How long will a 2gb memory card record on a sony handy cam?

Roughly, about 2 hours of straight video.

I have read a few articles about the performance of SD Cards, and would like a more definitive answer. I am looking at buying an insignia camcorder that records directly to an SD card. Is there a ""Specific" type of SD card that I need to be looking at? And can a 2GB SD Card really hold 2 hours of Video?

Thank You

Allyn Drew