we have many members with city=Hepworth, and many with city=Sauble Beach
yet when I show the directory pages

http://sbp.teledyn.com/profile/city/Hepworth

is empty, but

http://sbp.teledyn.com/profile/city/Sauble+Beach

yeilds results!

select distinct fid, value from sbp_profile_values where fid = 3;
...
|    3 | Hepworth                                             |

this may be because there is only one entry, but even more strange than this is the following

select count(value) from sbp_profile_values where value = 'Owen Sound';
+--------------+
| count(value) |
+--------------+
|            4 |
+--------------+
1 row in set (0.00 sec)

and yet http://sbp.teledyn.com/profile/city/Owen+Sound is an empty set!

the very curious thing about all this is the consistency in the inconsistencies ;) 'Hepworth' is always empty but 'Wiarton' is not, 'Sauble Beach' shows results, but 'Owen Sound' never does. The members in all cases are active members, authenticated users.

as an aside feature request, it would be nice if the profile-listing pages used a case insensitive partial match, ie where 'hepworth' == 'Hepworth' and 'Sauble' matches 'Sauble Beach'. The dynamic completion is a help in this regard, but I still find members will enter their own variations even for common terms like their own town's name.

I believe this is the Profile Extended module. The Issues Tracking didn't have an entry for just 'profile' and the profile.info file only says

; $Id: profile.info,v 1.3 2006/11/21 20:55:35 dries Exp $
name = Profile
description = Supports configurable user profiles.
package = Core - optional
version = VERSION

and the CVS status says

File: profile.info      Status: Up-to-date

   Working revision:    1.3
   Repository revision: 1.3     /cvs/drupal/drupal/modules/profile/profile.info,v
   Commit Identifier:   528f456367774567
   Sticky Tag:          DRUPAL-5-1 (revision: 1.3)
   Sticky Date:         (none)
   Sticky Options:      (none)