Solved

Multi Line Query

Posted on 2004-04-12
7
398 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
  • 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
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…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

896 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now