macro expansion works on character vars only. your var is numeric, try this instead ...

FOR lnCnt = 1 TO 10
   lcCnt = TRANSFORM(lnCnt)

   SQL_Text = "INSERT INTO testtable( empno,Solde ) SELECT empno,solde&lcCnt from mytable"

ENDFOR