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
Solved

SQL QUERY : JOIN

Posted on 2011-09-05
4
275 Views
Last Modified: 2012-05-12
Hey guys, i have a query below

"SELECT *, r_name as InfoWindowText, Latitude as Lat, Longitude as Lng FROM dbo.pretoria"


now how can i write a query where InfoWindowText must r_name+'<br> + name

i just want to assign text to InfoWindowText
0
Comment
Question by:JCWEBHOST
  • 2
4 Comments
 
LVL 22

Assisted Solution

by:pivar
pivar earned 250 total points
ID: 36483187
Hi,

Do you mean?

SELECT *,  r_name+'<br> + name as InfoWindowText, Latitude as Lat, Longitude as Lng FROM dbo.pretoria

/peter
0
 

Author Comment

by:JCWEBHOST
ID: 36483231
yes
0
 
LVL 15

Accepted Solution

by:
gplana earned 250 total points
ID: 36483233
The SELECT proposed by privar will fail. You need an additional quote after <br>:

SELECT *,  r_name+'<br>' + name as InfoWindowText, Latitude as Lat, Longitude as Lng FROM dbo.pretoria
0
 

Author Closing Comment

by:JCWEBHOST
ID: 36483263
thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 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