See, I knew I was having a brain cramp. ;-) Duh.

Thank you very much for pointing that out.

>Beth,
>Subquery would only return a single column.
>
>SELECT adnt.clientid + adnt.prjnum+adnt.comp_num FROM adnt
>
>Cetin