Just a reminder that SELECT only evaluates one expresstion, so if you are a member of say Chicago AND Nashville then only the Chicago code will run. SELECT runs the first true instance then ignores the rest.

If you have a CASE 1 statement in your SELECT and none of the other cases are true then this will run instead. CASE 1 = CASE ELSE.

cj

P.S. I went to Nashville High school here in Australia.