> On Tue, 8 Feb 2005 01:10 pm, CoL wrote: >> hi, >> >> Berend Tober wrote, On 2/7/2005 22:20: >> > I encountered what looks like unusually sorting behavior, and I'm >> wondering if >> > anyone can tell me if this is supposted to happen (and then if so, why) or >> if >> > this is a bug: -------------- > With 8.0.0 C local, SQL_ASCII Database, I get the expected output. > Russell Smith -------------- > order by case when account_id like '*%' then 0 else 1 end > C. Thanks. It was pointed out to me that this behavior is normal and is dependent on the locale setting. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
