Creating Group of names with having "A - L"

RootsMagic
1

Good Morning

Is there a way to search for Surnames (Starting with “A, B, C …” ( A through L ) like starting “<M” or “>=M”
(with out needing to do all 12 letters for example)

Kevin

2

By data fields
Surname greater than @
AND
Surname less than M
EDITED
TO INCLUDE
Surname greater than @
AND

1 Like
3

You may also need to search on Surname > Greater than or equal > A. Otherwise, you will probably get people with blank surnames.

1 Like
4

I’m thinking a blank surname field cannot be in a result set for anything but IS BLANK.

5

Nope. A blank surname is less than M.

However, I take your point. A “blank” surname in RM does not consist of blanks. Rather, it is a string consisting of zero characters. RM seems to display strings containing zero characters and to sort them ahead of strings containing more than zero characters. So the effect is that an “empty” surname matches a search for “less than M”.

1 Like
6

Thanks for catching that! Now, that I’m back home at my computer… I’ve edited my reply to add a lower bound.

7

RM probably defaults to an empty string because a null requires special handling when concatenating.

8

thank you everyone – I wanted to make sure I not missing anything

1 Like