Sorting in SQL Select

[Ruslan Zasukhin]

on 3/14/03 2:35 PM, Richard Altenburg at richard.altenburg at vergeerkaas.nl
wrote:

Hi Richard,

> I purchased Valentina last week for my company Brainchild, and am a happy
> user! 

Great!

> Now I do this select in sql where I like to order by a string field, and I see
> it is case sensitive.
> 
> I need to override this to make it sort exactly as realbasic does. Should I
> use the UPPER in my sql? And how do I do that (or any other expression, where
> can I use these)?

You need at first create in your table BaseObject method that use
Lower/Upper

Then use that BaseObject method in your SQL

    ORDER BY myFldLwr


Read FAQs.
It seems this question present there

> Or is there something else I should do to make words with a lowercase letter
> appear between those with uppercase? Now I get for example the order "Link",
> "Zip" and "lol", and what I need is "Link", "lol" and "Zip".

-- 
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://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------