>
> Message: 12
> Date: Thu, 15 Mar 2007 12:24:41 -0700
> From: "Dennis Birch" <[EMAIL PROTECTED]>
> Subject: Re: Setting REALSQLDatabase sorting style (Dennis Birch)
> To: "REALbasic NUG" <realbasic-nug@lists.realsoftware.com>
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 3/15/07, Giulio <[EMAIL PROTECTED]> wrote:
>> I would be interested too...
>>
>> anyway, I'm using as a workaround an upper() statement
>>
>> ORDER BY upper(fieldname)
>
> I haven't tried that, but wouldn't it convert the field text to all
> uppercase? That wouldn't work for me.
>
Oh, no.
the items returned by the select and the order by clause are separated
select upper(fieldname) from tablename order by upper(fieldname)
will return the data converted to uppercase and case insensitive
ordered, but
select fieldname from tablename order by upper(fieldname)
will return the data case insensitive ordered, but not converted
( lowercase wil remain lowercase )
Ciao,
Giulio
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
