How to do case insensitive SELECT?

Ken Ray kray at sonsothunder.com
Fri Jun 20 11:28:05 CDT 2003


> 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

Thanks, Ruslan!

Ken Ray
Sons of Thunder Software
Email: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/ 




More information about the Valentina mailing list