Thanks Bonnie.

I am not at their site right now but its kind of like this in foxpro:
lcstring = iif(ddlist1.SelectedText = "LEFT","L.H.",iif(ddlist1.SelectedText = "RIGHT","R.H.",.....))+" "+ ddlist2.SelectedText +" "+ ........

So a Case like statement in a T-SQL command is what I'm trying to do. I'm going to be using the StringBuilder too.



>Stephen,
>
>Maybe I'm being particularly dense today, but I don't understand what you're asking. Could you elaborate more?
>
>~~Bonnie
>
>
>>I need to build a string for a WebForm display. I have a need for a CASE statement to take the display from a drop down and concatinate it ie:
>>LEFT = L.H. RIGHT = R.H.
>>
>>I am combining 7 different dropdowns for this user request, and this is the sticking point I have so far.
>>
>>Any ideas?
>>
>>TIA
>>
>>__Stephen