>>>>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); 
>>> }
>>>

>>
>>You may also want to take a look at the HtmlHelper class for things like this. It is in the MVC namespace but there is no reason you can't use it in non-MVC apps.
>>
>
>Thank you. I will check it.
>>Isn't your monthly day off coming up? <g>
>>
>Mabye <g>.
>
>As to the rest of your message, Michel is very strict about technical thread etiquette. He just sent me a PM that he will ban both you and I if we discuss non-technical stuff in this forum.

That's funny, I got the same PM.