<div>
<div class="content wysiwyg-content">
Hey guys, i have a query below<br />
<br />
&quot;SELECT *, r_name as InfoWindowText, Latitude as Lat, Longitude as Lng FROM dbo.pretoria&quot;<br />
<br />
<br />
now how can i write a query where InfoWindowText must r_name+'&lt;br&gt; + name<br />
<br />
i just want to assign text to InfoWindowText
</div>
</div>


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

SQL QUERY : JOIN

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.