Problem:

Access appears to have a difference string sort order to Oracle. When i do a compare (good old equal, less than, greater than) based on string fields in which there is an underscore, the compare fails. The recordsets returned by JET and Oracle are supposed to be ins ascending sequence, however JET's interpretation of ascending is not the same as Oracle's.

Example:

Access places FR_ before FRA_ even though the _ has a higher ASCII code number to the letters

Oracle places FRA_ before FR_ thus appears to sort in the correct ASCII sequence

Challenge:

I've blown a fuse trying to read through MS documentation and experimenting. Has anyone ever had this problem before? if so how do I get round it.