> yeah districtno is text, unfortunately we have some districtno's that are > "10306C" so we have it as a text 7.
In that case TEXT is the correct data type. > in the locations table we have a bunch of locations for different districts > but district '67959' might have locno '010' and district '10306C' might also > have locno '010' so we are qualifying by districtno on both tables so 67959 > users dont see the location description from 10306C (its happened in the > past and it confused some people hehe). I don't need to tell you that you have a structural problem with the data, in that case. However, it might be clearer if you did: WHERE tranmaster.districtno = '67959' + AND tranmaster.locno = location.locno + AND tranmaster.districtno = location.districtno -- Larry
