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?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
