On Nov 9, 2019, at 12:25 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > Every time I saw a field called 'firstname' or 'second name' or 'surname' or > 'familyname' I groaned.
I just had a fight with my insurance company who had me sign up for their new web portal, which only asked for first and last name, but it kept telling me I wasn’t a customer. They’d been happily accepting my credit card payments for years, but I’m not a customer?! We eventually figured out what went wrong: on the paper sign-up form, they demanded my full legal name, which has a suffix. There was no spot on the form for my name’s suffix, so I put it after the last name, and their data entry drone put it in the database’s last-name field as “Young II”, so to their DBMS, there was indeed no “Warren”, “Young” row! _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users