ashishasr
New Contributor II

hi, In Databricks SQL stored procedures (Unity Catalog, DBR ≥ 17.0), the WHILE ... DO loop is supported, 
equivalent code for this, 

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