yes, there is a difference between sorts and comparisons. in 10g, for comparison behavior you can set the NLS_COMP parameter to ANSI. the default is BINARY. kind regards, Lex. --------------------------------------------- Visit my website at http://www.naturaljoin.nl --------------------------------------------- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Amihay Gonen Sent: Sunday, May 08, 2005 17:54 To: Oracle-L (oracle-l@xxxxxxxxxxxxx) Subject: difference between order by and between operators Hi , we have notice differences between the operator of order by and between. It seems that nls_sort effect only the order by sort operator , but not the between. -- //www.freelists.org/webpage/oracle-l