>now i know that foxpro defaults all characters to be delimited by commas and the actual value surrounded by quotes. however, since the numeric values never get surrounded by quotes, does anyone know how to accomplish this?
>
>i tried to str() the fields, but it did not work with the COPY TO command. Thanks
Run query into cursor with STR() or PADL() for numeric fields and the rest of fields unchanged. After that use COPY TO TYPE DELIMTED to copy cursor to text file.
BTW, why do you need numeric values in quotes?
--sb--