Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Michael Hagl" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Wrong Sort Order of Index Date: Fri, 25 Aug 2017 11:49:43 +0200 Lines: 44 Message-ID: References: X-Trace: individual.net x1q/8joehVEEmVA/8r5HFgPFlJjqkw/d6/HCjdKhGtHT+7U545 Cancel-Lock: sha1:x8C9WZnjMXkA7XhBB59HM8YqCac= X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 X-RFC2646: Format=Flowed; Original Xref: csiph.com comp.lang.clipper.visual-objects:10930 Hi Jürgen, I have do some tests: (ADS-12, OEM- und ANSI-Character Set is setting to GERMAN),l but xHarbour Sort result "Upper(text1)" as it should aaa aaa-bab aaa-bbc aaa-bcb abc adb I dont think that "-" Chr(45) is a special character and charset or collation doesn´t matter. Are you sure that the last char behind aaa ist a space (Chr(32))? Michael Hagl "Jürgen Knauf" schrieb im Newsbeitrag news:d1f59ccc-5ed8-40b0-8cec-55b885373f14@googlegroups.com... There is a strange bug in Advantage Database Server 12. When there is the special Character "-" in a string of a data field with an Index, Advantage Database Server do not find the correct records. The sort order of the index "UPPER(ARTICELNO)" is wrong: Example: aaa-bab aaa-bbc aaa-bcb aaa abc abd What can I do? Jürgen Knauf