Hi
Change your query to this way
Select col1 + col2, col1 from table1
HTH
Ravikanth[MVP]
[quoted text, click to view] >-----Original Message-----
>how can I populate one dropdownlist field from two
>seperate database fields eg. product number and product
>description on one line? I'm using the ie webcontrols
>.