David - thanks for the info on the sort order, nice of Access to make you port all your objects to another database. I'll check that out when I get the time. I've given up for this afternoon - this is actually in a query slightly more complex than the test one I explained the problem with.
The query is to find duplicate security IDs within a set of linked tables, but TA.TO and Ta.TO are different. It does this by checking to see if a COUNT result is >1. COUNT=2 for TA.TO, even though they're not the same! Maybe I can write a function which returns the count of lower case characters and concatenates this to the end of the security code, then takes a count, and if any are greater than 1 takes the final character off the result and returns that.
I'll keep you posted if I get a solution this way.
Thanks for the help,
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.