>>>How can I get a CR added to the end of the last column in a SQL Select?
>>
>>The question is unclear, but take a look at CHAR() function.
>
>What is unclear?
>
>Add a CR at the end of last columen in a SQL Select. Not sure how to say it differently for you.

If this is in the select statement, then

select col1, ... colN + char(13) from ...

I would assume this is what you're looking for.