Prevent exported SQL.csv output from breaking up row of text over multi columns

Thanks for your quick response,
Can this code accomodate seveal columns?
Here's asilly question, but I'd like to be sure:
Does this code actually scan the data that is to be outputted and replace the characters or does it make the replacement in the live table data?

Thank you.

You would just duplicate this code to use for other columns like:

SELECT column0,
REPLACE(column1, CHAR(13) + CHAR(10), ' '),
REPLACE(column2, CHAR(13) + CHAR(10), ' '),
REPLACE(column3, CHAR(13) + CHAR(10), ' '),
column4,
column5
FROM table1

This is only replacing the value for the resultset of the query.  If you want this to be replaced in the live data, you can change to an update statement.

You escape commas by encasing the value of the field in quotes (single or double), and then escape instance of those quotes inside the value by placing two of them adjacent.  At this point you shouldn't need to worry about line breaks, but sometimes software won't handle them correctly so if you still have a problem I prefer replace them with a tab.

The result for each column looks like this:

'''' + REPLACE(REPLACE([columnname], '''', ''''''), CHAR(13) + CHAR(10), CHAR(9)) + ''''

You might also want to turn that into a user-defined function, to save typing in your queries, make it clear what you're doing, and so if you change your newline delimiter you only have to do it in one place.

I am not an Excel expert, but I believe you can set options that will tell excel not to break the lines. Look in the help under "Import a text file".
<table class="OTbl" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="cdONBodyCellUnpadded"></td></tr></tbody></table>

Thank you all for your contributions. I am having a hard time actually utilizing and integrating these ideas into my code. I would appreciate any instruction on how to creat/use a user-defined function in Query Analyzer.
The Code is attached

Thanks.

SELECT 
       People.LastName, People.FirstName,     
       ObjectiveActionPlans.ActionPlan, AnnualObjectives.Goal
FROM   
       AnnualObjectives INNER JOIN
       ObjectiveActionPlans ON AnnualObjectives.ID =            
       ObjectiveActionPlans.ID INNER JOIN
       ObjectiveReviews ON AnnualObjectives.r_DevelopmentReview = 
       ObjectiveReviews.ID INNER JOIN
       People INNER JOIN
       Years ON People.ID = Years.r_Person INNER JOIN
       ObjectiveReviews ON Years.ID = ObjectiveReviews.r_PersonYear   
       ON ObjectiveReviews.r_PersonYear = 
       Years.ID INNER JOIN
       ObjectiveResults ON AnnualObjectives.ID = ObjectiveResults.ID    
       INNER JOIN ObjectiveComments ON AnnualObjectives.ID = 
       ObjectiveComments.ID
WHERE  
      (Years.[Year] = 2008)and (People.LastName = 'Doe')and 
      (people.firstname = 'Jane')
		
ORDER BY 
       People.LastName

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:

Assuming you were able to execute my CREATE command successfully, to use the function you would change the select clause of your query like this:

SELECT 
       dbo.CleanForCSV(People.LastName) As LastName,
       dbo.CleanForCSV(People.FirstName) As FirstName,     
       dbo.CleanForCSV(ObjectiveActionPlans.ActionPlan) As ActionPlan,
       dbo.CleanForCSV(AnnualObjectives.Goal) As Goal
                                              

1:
2:
3:
4:
5:

I first ran the CleanForCSV function above with now problems. Now after running my query I am getting the following errors:

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.CleanForCSV'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.CleanForCSV'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.CleanForCSV'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.CleanForCSV'.

I then removed the dbo. prefix and now get the error below:

Server: Msg 195, Level 15, State 10, Line 2
'CleanForCSV' is not a recognized function name.

Check in sql server management studio and make sure the function exists in the database.

I see it under the functions folder

Ok, I finally took a closer look. The function get renamed with my username.CleanForCSV