• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 414
  • Last Modified:

Multi Line Query

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
moralju
Asked:
moralju
  • 5
  • 2
1 Solution
 
gregoryyoungCommented:
[Field1] & vbcrlf & [Field2]

now I am not quite sure if you are referring to the access side or the vb.net side but :)
0
 
gregoryyoungCommented:
wait you must mean the SQL side ... that is DB dependant what DB are you using ?
0
 
moraljuAuthor Commented:
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
gregoryyoungCommented:
full example.

authors.first_name + Char(10) + Char(13) + authors.last_name AS AuthorName
0
 
moraljuAuthor Commented:
Thats what I was looking for...

thanks...

fast response by the way!!!
0
 
gregoryyoungCommented:
anytime :)
0
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now