[V4MD] Order By Command

[Ruslan Zasukhin]

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