How to do case insensitive SELECT?

[Ruslan Zasukhin]

on 6/20/03 7:00, Ken Ray at kray at sonsothunder.com wrote:

> Hey,
> 
> I'm doing a query on a table that is retrieving all the records and
> sorting on a field in the DB. When it comes back, the data is sorted by
> ASCII value (I assume that is 'case sensitive') and I want it case
> insensitive. Any suggestions? I don't have a WHERE clause so I can't use
> the 'no case' option. Here's my query:
> 
> SELECT RecID,FileAs FROM Entities ORDER BY FileAs
> 
> And my last two records are:
> 
> 7134 Zzyzyx Corp.
> 836  cYclops Unlimited
> 
> As you can see, the "c" is sorting after the "Z" and not with the "C"s.
> 
> Any ideas?

Hi Ken,

You need to use then BaseObject method FileAsLwr = lower(fileas)

Now you can use it in query

 SELECT RecID,FileAs FROM Entities ORDER BY FileAsLwr

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