Overcome BCP limitations for output to CSV file

This is an example to overcome short comings when using BCP to create a 'proper' CSV file. The view vw_Customers_RAW is used in order to provide a method of creating the column heading row and to enclose columns with embedded comma with double quotes, which are not options in BCP. There are more generic methods of creating the Header row using system tables, I elected to use text instead. This example uses the Northwind database's Customers table, so 'should' be available on most SQL Server 7/2000 systems. Many thanks to members of this forum for the ideas that are shown here. Enjoy, Andy