[SQL] question about "ORDER BY" statement

[Ruslan Zasukhin]

on 10/21/03 21:25, SoftIl at softil at onlinehome.de wrote:

> Hi Ruslan,
>> You need to use BaseObject method to get this
> Which method do you mean?


You need create BaseObject method

    FldLwr = lower(fld)

And use it in query

    SELECT fld FROM T ORDER BY fldLwr

 
> Best regards,
> Carsten
> 
> 
>> ----- Original Message -----
>> From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
>> To: <valentina at lists.macserve.net>
>> Sent: Tuesday, October 21, 2003 11:10 AM
>> Subject: Re: [SQL] question about "ORDER BY" statement
>> 
>> 
>>> on 10/21/03 11:59, SoftIl at softil at onlinehome.de wrote:
>>> 
>>>> Hi,
>>>> if there is a possibility to supplement the "order by" sql-statement
>> with
>>>> "no_case"?
>>>> Example:
>>>> "select * from TableName order by FieldName no_case"  //that statement
>> gets an
>>>> error back "field no found".
>>> 
>>> Hi Carsten,
>>> 
>>> You need to use BaseObject method to get this

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