>I'm doing a "COPY TO 'filename' TYPE CSV" from a vfp cursor.
>
>Everything is good except I need the first line in the csv file (which are the fields) to be upper case. One solution I thought about is opening the file and go character by character and changing to uppercase. Any other way to accomplish this?
>
>Thanks.
COPY TO ......
lcFile = FILETOSTR([NewlyCratedCSVFile.CSV])
lnAt = AT(CHR(13), lcFile)
STRTOFILE(UPPER(LEFT(lcFile, lnAt-1))+SUBSTR(lcFile,lnAt),[NewlyCratedCSVFile.CSV], 0)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.