diff options
| -rw-r--r-- | library/WT/Query/Name.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/library/WT/Query/Name.php b/library/WT/Query/Name.php index fb11f83faa..1cf31feee1 100644 --- a/library/WT/Query/Name.php +++ b/library/WT/Query/Name.php @@ -229,9 +229,9 @@ class WT_Query_Name { } // Now fetch initial letters that are not in our alphabet, - // including "@" (for "@N.N.") and "" for no surname + // including "@" (for "@N.N.") and "" for no surname. $sql= - "SELECT LEFT(n_surn, 1), COUNT(n_id)". + "SELECT UPPER(LEFT(n_surn, 1)), COUNT(n_id)". " FROM `##name` ". ($fams ? " JOIN `##link` ON (n_id=l_from AND n_file=l_file AND l_type='FAMS') " : ""). " WHERE n_file={$ged_id} AND n_surn<>''". @@ -301,7 +301,7 @@ class WT_Query_Name { // Now fetch initial letters that are not in our alphabet, // including "@" (for "@N.N.") and "" for no surname $sql= - "SELECT LEFT(n_givn, 1), COUNT(DISTINCT n_id)". + "SELECT UPPER(LEFT(n_givn, 1)), COUNT(DISTINCT n_id)". " FROM `##name` ". ($fams ? " JOIN `##link` ON (n_id=l_from AND n_file=l_file AND l_type='FAMS') " : ""). " WHERE n_file={$ged_id} ". |