John Colby
jcolby at colbyconsulting.com
Wed Aug 13 16:59:11 CDT 2003
Nope. Concatenated fields are just a text string to the query engine. However if you dragged the last and first name out into the query (even if hidden), then sorted on those fields, it would sort in that order (of course) and indexes on those fields would speed the sort. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark Whittinghill Sent: Wednesday, August 13, 2003 2:33 PM To: accessd at databaseadvisors.com Subject: [AccessD] Indexes on text fields 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com