DECLARE @students TABLE (firstname varchar(20), lastname varchar(20))

INSERT @students
VALUES
  ('John','Olson')
 ,('Richard','Hooton')
 ,('Tina','Trout')


 SELECT *
 FROM @students s
 WHERE s.firstname + s.lastname LIKE '%o%o%o%'