>Month1 is a number field in a table. I want to select this field in a SQL select statement but to change the field name returned with a corresponding date from an array of dates. I know that I have to convert the date into a character string so it can be used as a valid column returned by the SQL statement.
>
>Example Select code, department, month1 as dtos(laMonths[1]) from file1 into cursor file2.
>
>Can this be done ?
lcFieldName = "_"+dtos(DATE())
Select code, department, month1 as &lcFieldName;
from File1;
into cursor file2
BROWSE NORMAL
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.