URGENT:Retrieving data from the database

Wrox Programmer Forums

		Wrox Programmer Forums > SQL Server > SQL Server ASP
URGENT:Retrieving data from the database

SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

October 21st, 2004, 01:28 AM

jyoti_khera jyoti_khera is offline

jyoti_khera is offline

Authorized User

Join Date: Oct 2004

Posts: 16

Thanks: 0

Thanked 0 Times in 0 Posts

Default

URGENT:Retrieving data from the database

Hi ,

can anyone suggest me how to retrieve the data in the following manner from the table

Lastname,Firstname

lastname and the first name are the two different columns in the table

Old

October 21st, 2004, 03:01 AM

madhukp

madhukp is offline

Friend of Wrox

Join Date: Oct 2003

Posts: 463

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via MSN to madhukp

Default

You can use the following query.

SELECT (Lastname + ', ' + Firstname) AS [name] FROM tblSubscribers

Where tblSubscribers is the DB table where these two columns are defined.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Urgent inserting data to database from xml File	Venkata Krishnan	ADO.NET	1	November 8th, 2005 08:58 AM
retrieving from database... URGENT!!!	roryosullivan	JSP Basics	1	March 9th, 2005 03:11 PM
Displaying Data in TextBox From Database(Urgent)	gadhiav	ASP.NET 1.0 and 1.1 Basics	2	June 17th, 2004 12:20 AM
Displaying Data in Textbox from Database(URGENT)	gadhiav	Classic ASP Databases	1	June 16th, 2004 02:06 AM
NEED HELP! retrieving from database	nvillare	ADO.NET	1	December 2nd, 2003 10:31 AM