High HLB sucrose esters (Sisterna PS750, SP70 and SP50) are soluble in water.
Medium HLB sucrose esters (Sisterna SP30) are partly soluble in water and partly in oil/fat.
The higher the HLB value, the better soluble in water. Sisterna SP70 and PS750 are well soluble in cold water, the latter forming a clear solution.
An instruction video how to dissolve sucrose esters in water can be found here:

Sisterna sucrose esters - Water solubility from Sisterna on Vimeo.