Mark Whittinghill
mwhittinghill at symphonyinfo.com
Wed Aug 13 13:33:03 CDT 2003
Let's say I have a Person table with FirstName and LastName fields. Both are non-unique indexed to help searches. Now say I build a query with a concatenated field FullName: LastName & ", " & FirstName. Will the indexes on these fields help speed searches on the FullName field? Mark Whittinghill Symphony Information Services 612-333-1311 mwhittinghill at symphonyinfo.com