sql*server and MSAccess ascii sort order
Posted by:
Allan Ford
Date: November 06, 2006 06:29PM
Hi,
Does anyone know if sql*server (and MSAccess and excel) can sort data by ascii value.
i.e. Oracle sorts by ascii dec value but MS Access sorts by it's own defined sort order.
e.g. Oracle will sort an underscore after capital letters, MS Access will sort an underscore before capital letters ..
I'd like some way of either getting Oracle to sort the same was as Microsoft or vica versa ..
regards
Allan
Subject
Views
Written By
Posted
sql*server and MSAccess ascii sort order
6378
November 06, 2006 06:29PM
3076
November 06, 2006 08:45PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.