thanks a ton everyone! here is what i ended up with:

select top 1 *

from

(

select name, address, zip from mytable where name='my_name'

union all

...

We had a similar issue porting our app from 2005 to 2008 - this fix did the trick, thanks for the post!