SQL While do loops

elgeo
Valued Contributor II

Hello. Could you please suggest a workaround for a while do loop in Databricks SQL?

WHILE LSTART>0 DO SET LSTRING=CONCAT(LSTRING, VSTRING2)

Thank you in advance