SQLite Forum

How can I split a name column into first and last names?
Login
How can I split a name column into first and last names and view a specific first name using queries? I have a table called people and I need to find out how many people in this table (which has a column called 'names') have the first name 'MERYL' using the Execute SQL tab.