How to create transparent texture

I need to create a texture that has parts of it transparent, like a 2D sprite.