Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  BCP and Null's?

Author  Topic  gelwood Starting Member 8 Posts Posted - 2011-07-06 : 15:31:09 I am creating a CSV file from a stored procedure and then loading the file into a Lawson application. Every place i have a null in the file i end up with a "À€" set of characters. Does this have something to do with BCP and Nulls? How do i get rid of this? Thanks ----------------------------------------------------------------- DECLARE @sql varchar(8000) SELECT @sql = 'bcp "select * from TEST..HRIMPUT" ' + 'queryout E:\CasSpool\employee_feed_ShelteringArms.csv -c -t, -T -S '+ @@servername EXEC master..xp_cmdshell @sql ----------------------------------------------------------------- À€ 10 ADAMS REBECCA SAHSOUTHIP À€ 11/30/2009 À€ À€ À€ À€ 2024 EMPLOYEE À€ 430 BON AIR