Solved

Multi Line Query

Posted on 2004-04-12
7
402 Views
Last Modified: 2012-06-27
Here is a simple question but I will offer 500 pts b/c I've been looking for a while and can't find the answer.

how can I create a multi line query for example in Ms Access I do this:
[Field1] & Chr(13) & Chr(10) & [Field2] as expr1

I want to recreate the same in vb.net query.
0
Comment
Question by:moralju
[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
  • 5
  • 2
7 Comments
 
LVL 37

Expert Comment

by:gregoryyoung
ID: 10810055
[Field1] & vbcrlf & [Field2]

now I am not quite sure if you are referring to the access side or the vb.net side but :)
0
 
LVL 37

Expert Comment

by:gregoryyoung
ID: 10810061
wait you must mean the SQL side ... that is DB dependant what DB are you using ?
0
 
LVL 1

Author Comment

by:moralju
ID: 10810106
I'm using SQL with a vb.net interface.
When I configure the sqlAdapter I create a query to filter the data.
thats where I want to add the multi line field...
0
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 
LVL 37

Expert Comment

by:gregoryyoung
ID: 10810133
0
 
LVL 37

Accepted Solution

by:
gregoryyoung earned 500 total points
ID: 10810136
full example.

authors.first_name + Char(10) + Char(13) + authors.last_name AS AuthorName
0
 
LVL 1

Author Comment

by:moralju
ID: 10810273
Thats what I was looking for...

thanks...

fast response by the way!!!
0
 
LVL 37

Expert Comment

by:gregoryyoung
ID: 10810283
anytime :)
0

Featured Post

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

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

Suggested Solutions

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

739 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