SQLite Forum

How can I split a name column into first and last names?
Login
That would be "like 'meryl %'" unless you wanted 'merylithium tarnish' or 'meryltok dogwood' to satisfy the criteria.  Of course if the person had only one name that was 'meryl' this would not work either.

This is why "Given" and "Family" names are usually stored separately.  There is also nothing which requires the "first token" to be the given name.  In many cultures the "first token" is the family name or even a dead word.