this is really close, the only problem is that there can be more than one city name in two different states. like a boston, MA and a boston, NY or something. and they need to be treated seperately. thanks for your help so much!
Ryan