I have a table with the fields:
zip, dname, address, city, phone.
and a stored procedure:

SELECT zip AS [Zip], dname as [Name], address + CHAR(13) + city AS [Address], phone AS [Phone]
FROM Dealers ORDER BY zip ASC
GO

and a DataGrid using only bound columns from the stored procedure.

My intent is to have only 3 columns in the DataGrid at run time, in which the middle column, Address, contains both address and city wtih a carriage return between output in the same Address column.

The result at run time is a DataGrid with 3 columns but no carriage return.

How can a carriage return be inserted in a column in a DataGrid.

Thanks for your help.


Sandra MacGregor

__________________
Sandy

Even though you have a carriage return in the SQL, you won't see it in the rendered HTML. You should change it to a HTML break:

SELECT zip AS [Zip], dname as [Name], address + '<br>' + city AS [Address], phone AS [Phone]
FROM Dealers ORDER BY zip ASC
GO


Peter
------------------------------------------------------
Work smarter, not harder.

Peter,

That works perfectly!

I'd tried putting <br> in the INSERT statement many ways to no avail, and didn't think of putting it in the sp.

Thanks a lot.



Sandra MacGregor