Hi everybody,

This should be a very simple question. I have a SQLDataSource to Display School. I added a new field called SchoolPhone and I'd like to display both fields in my DropDown.

Here is what I've tried

<asp:SqlDataSource ID="SchoolsDataSource" ConnectionString="<%$ ConnectionStrings:FCCMSConnectionString %>"
        
        SelectCommand="SELECT RTRIM([School]) + ' - ' + [SchoolPhone] as SchoolInfo, [School], [SchoolPhone] FROM [Schools] WITH (NOLOCK) WHERE ([siteID] = @siteID)" 
        runat="server">

but it still only displays School. Should I try to bind to SchoolInfo?

Thanks in advance.

UPDATE. Yes, seems to work. Auntie Emma syndrom again.