Concatenated string column is not displaying properly in dropdown list(asp.net)

Question

Hi all,

Below is my query which is in Storedprocedure(SQL Server 2008) will return list of items from a table.

Query:

SELECT 
( COALESCE(ReviewDescription,'')+ REPLICATE (' ', 20 - LEN(ReviewDescription))
+ '|' + 
( CONVERT(VARCHAR(100),ReviewCharge))) AS ReviewTypes
FROM ReviewType

query result(copied to text pad then its looking like below):

Sample review type    |200

But after binding to ASP drop down control it is displaying like below drop down display:

Sample review type|200

Please some one can help on this.

Thanks in advance...

Answer 1

It sounds like it could well just be the browser collapsing whitespace. Look in the HTML source to see what's actually being sent down. Then you can determine whether it's a problem in the display or the data access.

(I'm not sure this is really a good way of displaying a pseudo-table in a drop-down, to be honest.)