>Trying to build SQL from a RowSource. I want to turn this:
>

>vNewVal = "Race.RaceCode, RaceDesc"
>

>Into this:
>

>"SELECT RaceCode AS F1, RaceDesc AS F2 FROM Race"
>

You might also look at.......

FUNCTION sqlParse
LPARAMETERS vNewVal

**vNewVal = "Race.RaceCode, RaceDesc"
**  Assumes first phrase has the table name.field
**  Assumes remaining phrases are just fields
LOCAL lcSql, I

lcSQL = ""

FOR I = 2 TO GETWORDCOUNT(vNewVal,".,")
	lcSql = lcSql + ", " + GETWORDNUM(vNewVal,I,".,") + " AS F" + TRANSFORM(I-1)
ENDFOR

RETURN "SELECT " + SUBSTR(lcSql,2) + " FROM " + GETWORDNUM(vNewVal,1,",.")