[V4MD] Order By Command

[Mahesh Markus]

Thanks


-----Original Message-----
From: Ruslan Zasukhin [mailto:sunshine at public.kherson.ua] 
Sent: Tuesday, 10 February 2004 6:41 PM
To: valentina at lists.macserve.net
Subject: Re: [V4MD] Order By Command


on 2/10/04 8:29 AM, Mahesh Markus at maheshm at uniqueworld.net wrote:

> I noticed that the Order By command presents its information based on 
> the case of the fieldText.
> 
> Example:
> 
> SELECT LastName, FirstName
> FROM    tblUsers
> Order By LastName, FirstName
> 
> will return the following result set.
> 
> Admin    Admin
> Admin    Elizabeth
> admin     admin
> admin     elizabeth
> 
> 
> How can I make this sort order case insensitive?

Hi Mahesh,

I think this present in FAQs

You need make BaseObject Method
    LastNameLwr = "lower(LastName)"


And use it in the ORDER BY

-- 
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