> > I was really hoping to avoid such a thing if at all > name.downcase]) end > find( :all, :conditions => [ 'name ~* ?', name ] ) > > I'm pretty sure that by using a regex... it'll use the index. > > Robby And, if not, you can always setup an expression index for the lower() function on columns where you regularly do that. :) Regards, Dan This communication is the property of Qwest and may contain confidential or privileged information. Unauthorized use of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy all copies of the communication and any attachments.
on 2006-04-24 18:02