I have a table that contains names of employees, for example the field is called a name and contains " Jhon Smith McCartney " I need to find those which name is Smith and to leave them in another table how can I do it? I need to find a str inside a str and to leave the records in another table