V4MD: case insensitive ORDER BY

[martinpallett at netscape.net]

Thanks for the prompt reply Ruslan - makes sense now that I think about it.

cheers,

Martin

Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:

>On 3/21/05 2:55 PM, "Martin Pallett" <martinpallett at netscape.net> wrote:
>
>Hi Martin,
>
>> this should be really easy, but I haven't been able to come up with the
>> answer.
>> 
>> Here's what I want to do:
>> 
>> SELECT * FROM names WHERE recID >0 ORDER BY lastname asc, firstname asc
>> no_case
>
>No_case -- can be used only with LIKE
>
> 
>> which doesn't work, so I tried
>> 
>> SELECT * FROM names WHERE recID >0 ORDER BY upper(lastname) asc,
>> upper(firstname) asc
>
>This is almost correct.
>
>Just you need define in your Table BaseObject Method (calculated field)
>With such formula
>
>        upper( fld )
>
>Then you will use this method in the ORDER BY.
>    
>    ORDER BY fldUpr
>
>
>> which also doesn't work
>> 
>> Unfortunately, I can't force the case of the names stored in the table,
>> and some of them are only a first name.
>> 
>> Is there an easy way to do this, or do I have to create duplicate fields
>> in the database in all uppercase and order by them?
>> 
>> Thanks in advance for any suggestions.
>
>-- 
>Best regards,
>Ruslan Zasukhin      [ I feel the need...the need for speed ]
>-------------------------------------------------------------
>e-mail: ruslan at paradigmasoft.com
>web: http://www.paradigmasoft.com
>
>To subscribe to the Valentina mail list go to:
>http://lists.macserve.net/mailman/listinfo/valentina
>-------------------------------------------------------------
>
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina
>

__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp