How to find constituents with user names that aren't the same as their email addresses?

Adrienne Figus · October 2009

My organization uses the email address as the user name for simplicity, and very few of our constituents change them (we have an older, less tech-savvy constituency). Occasionally though, mostly through human error while synching with our offline database or when merging duplicate records, users end up with a different, perhaps out of date, email address as their user name. This causes confusion when they try to log in, of course. Generally we simply straighten these out as we get complaints, but I'd like to be able to come up with a query or task that can find a list of these problems so I can keep on top of them before our members run into the problem.

Any ideas?

Bryce Katzman · October 2009

I doubt there is a query or report that can do this for you, but it's doable in Excel.

James Zetlen · October 2009

You can't use Query to test if one field is identical to another field, but you could test to see if the username field seemed to be an email address. Create a Query which tests if Email contains "@". That could get you a little ways down the road! It would fail, of course, with constituents whose usernames were still email addresses, but they had changed their actual email address at some time...but it's better than nothing.

How to find constituents with user names that aren't the same as their email addresses?

Comments

Categories