I used the following code, see if it makes any sence

*-- Step 1.
=SQLEXEC(gnC, "SELECT name AS name1 FROM customer", "cTemp")

*-- Step 2.
SELECT cTemp.*, thisform.GetName(cTemp.name1) AS name FROM cTemp INTO CURSOR cTemp READWRITE

*-- Function GetName
LPARAMETERS tcName

tcName = ALLT(tcName)
lcLastName = allt(SUBS(tcName,1,at(",",tcName)-1))
lcFirstName = allt(SUBS(tcName,at(",",tcName)+1, 40))
tcName = allt(lcFirstName)+" "+allt(lcLastName)

tcName = PADr(tcName, 40," ")

RETURN tcName


Raz