Robert,
Here are some veriations that are close.
COPY TO ExpFile.Txt DELIMITED WITH ~
This yields an export file delimited with ~ and flds separated by commas.
COPY TO ExpFile.Txt DELIMITED WITH ~ WITH CHARACTER ~
This yields an export file delimited with ~ and flds separated by ~.
A work around might be something like
SELECT;
[~] + STR(NmbrFld1) + [~~] + ChrFld1 + [~~] + STR(NmbrFld2) + [~~] + ChrFld2;
FROM SrcFile;
INTO CURSOR crsExp
SELECT crsExp
COPY TO ExpFile.Txt TYPE SDF
-myron kirby-
=======================================
>I think I have not made myself understood.
>
>I am performing a COPY TO to an ASCII file. I prefer to delimit the ASCII file with a tilde (~). I need to have a tilde between ALL fields with NO OTHER DELIMITER in the file so I can BCP the data into SQL Server 6.5.
>
>If I do [COPY TO xx.txt DELI] then I get quotes and commas. If I do [COPY TO xx.txt DELI WITH "~"] then I get commas around the numeric data and ~ around the character data. If I do [COPY TO xx.txt DELI WITH "~"] then I get tildes around the numeric data and quotes around the character data.
>