Quote Originally Posted by rdove
in your SQL statement you could do:

Select SEG_ID + ' - ' + SEG_NM as ConcatField From .......

Then

ddSegID.DataTextField = ("ConcatField")
Thanks RDove someone already suggested this and i amended my stored procedure.

Cheers