Subject Re: [IBO] FW: Uppercase
Author Jason Wharton
It probably has to do with the ORDER BY situation. It doesn't allow you to
use the UPPER( ) function in the order by clause. You should maintain an
uppercase equivalent column in your table and use it in the ColumnAttributes
NOCASE setting for this to work 100%.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Rik" <rik@...>
To: <>
Sent: Wednesday, April 04, 2001 5:21 AM
Subject: [IBO] FW: Uppercase

> -----Oorspronkelijk bericht-----
> Van: Rik [mailto:rik@...]
> Verzonden: dinsdag 27 maart 2001 8:28
> Aan: ''
> Onderwerp: Uppercase
> Hello,
> My customer can enter upper and lowercase characters in a field. When I
> order and search in that field IBO sorts this field : first the uppercase
> and then the lowercase and so he can't search right.
> I flagged already the 'case insensitive' in the columnattributes.
> What do I wrong ?
> rik@...