how to use functions

[shaddf]

is it possible to insert data from such a select like so:

loop1: WHILE i<in_Dept_TOT DO
     
    INSERT INTO _epttbl(Project_id,Dept_id)  VALUES(Result,SELECT SPLIT_STRING(in_Deptid, '||',i));
    SET i=i+1;
END WHILE loop1;

Or  is it better likeso:

loop1: WHILE i<in_Dept_TOT DO
    SELECT SPLIT_STRING(in_Deptid, '||',i) into myvar ;
    INSERT INTO _epttbl(Project_id,Dept_id)  VALUES(Result,myvar);
    SET i=i+1;
END WHILE loop1;

[Jacques1]

The SELECT keyword in your first query is misplaced. Either leave it out entirely (just write down the function call expression) or enclose the subquery in parentheses. So it's either

SPLIT_STRING(...)

or

(SELECT SPLIT_STRING(...))