>Hi,
>
>I have a drop-down list control on the form. The .DataSource of this control is a dataview (from a dataset) created with the following SQL Select
>
>

>select MyField1, MyField2 from MyTable
>

>
>I want to create a column that will have MyField1 and then bunch of spaces and then MyField2. But when I add space to the SQL Select, the spaces are not shown. If I add '& + 'nbsp' + ';' still does not work. Here is an example of what I tried:
>
>

>select MyField1 + '            '  + MyField2 as MyField3 from MyTable
>

>or
>

>select MyField1 + '&' + 'nbsp' + ';' + '&' + 'nbsp' + ';' '  + MyField2 as MyField3 from MyTable
>

>
>
>What would you suggest?

UPDATE. Here is the solution:

foreach (ListItem item in ddlist.Items) 
 { 
    item.Text = HttpUtility.HtmlDecode(item.Text); 
 }