Message
 
 
To
15/06/2008 11:23:39
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01323980
Message ID:
01324270
Views:
15
>>>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.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View