Hi,

not an answer to your initial question, but an addendum: Why not just use a join or subselect? This saves really roundtrips and (real) databases are very good in this. Example:

select code from othertable
where year = ?
and state in (select state from mytable where city = ?)
[download]

Regards
McA