Hi,

I am sorry to post my answer accidentally before I am done:

(Continued)

     . delete the temporary table

All of the 4 steps above can be in one stored procedure.

If you want, you can even:

-modify step #2, replace any comma by ~

-create a macro in excel to convert all '~' to ',' then set it up to run again the the output file. If you are not familiar with macro, you can carry out this step manually.

Another solution:

. Export the original table to xls file

.Replace all ',' with '~' or sapce

. Save the xls to csv format

If you need further help, please email me at lamd@vmcmail.com

VMC-WED-MIS-DL