>>USE myview NODATA >>INDEX ON KeyID TAG KeyID >>INDEX ON KeyDesc TAG KeyDesc >>=REQUERY('myView')>>
use Billing_Rates_View NODATA
index on Last_name+First_name tag Name
index on ALLTRIM(Last_Name) tag LastName
index on PADR(Last_Name,30) tag LastName2
=REQUERY('Billing_Rates_View'Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.com
Never mistake having a career with having a life.