Improve company productivity with a Business Account.Sign Up

x
?
Solved

Multi Line Query

Posted on 2004-04-12
7
Medium Priority
?
413 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 37

Expert Comment

by:gregoryyoung
ID: 10810133
0
 
LVL 37

Accepted Solution

by:
gregoryyoung earned 2000 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…
Watch the working video to know how to import Outlook PST/OST files to Amazon WorkMail. Kernel released this tool which is very easy to use and migrate single or multiple PST and OST files to Amazon WorkMail. To know more about Kernel Import PST to …

595 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