Say I have a table with an index that is built from 4 fields. These fields are alpha, mixed case. The index key puts the function lower on them and only uses a substr of the first 40 characters of the last field in the index. Using the view builder the fields have to be listed one at a time, you can't bracket a list of all of them in a function statement, etc. Plus I only need to seek on the first two fields in the index but to make rushmore function you must compare what you're seeking to the entire index key. Below is the code that i'd iuse. How would you mimic it using only views?

*** This is a Rushmore optimized select:
*** Key is the index key definition, if I were programming I'd actually
*** get this defination by settin the table order
*** to this tag and using the key() function

ckey = lower(subject+author+title+left(subtitle,40))
csubject = "ref"
cauthor = lower("Jones")
select * from title where &ckey = cSubject+cAuthor