Solved

Adding a CRLF to a Select query?

Posted on 2007-04-09
4
836 Views
Last Modified: 2008-01-09
SELECT *, ISNULL(ClientInCareOf,'') + char(13) + ISNULL(ClientAddr1,'') + char(13) + ISNULL(ClientAddr2,'') AS ClientFullAddress FROM ClientTable(NOLOCK) WHERE RecID ='" & ReturnValue & "'

I can't seem to get this to work, what am I missing?

Thanks.
0
Comment
Question by:ApexCo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 23

Expert Comment

by:Saqib Khan
ID: 18877138
Try this

"SELECT *, ISNULL(ClientInCareOf,'') + '<br>' + ISNULL(ClientAddr1,'') + '<br>' + ISNULL(ClientAddr2,'') AS ClientFullAddress FROM ClientTable(NOLOCK) WHERE RecID ='" & ReturnValue & "'"



0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 50 total points
ID: 18877353
CRLF is CHAR(13) + CHAR(10)
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 18877365
>>I can't seem to get this to work, what am I missing?<<
Also, please elaborate what you mean by this.
0
 
LVL 8

Author Comment

by:ApexCo
ID: 18877770
Once I added them both in I got what I was after.

Thanks.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question