My application works just fine inserting all the data in the intended column. If there is only one entry in that column my search will find it. If there is 2 entries in that column IE first and Last name nothing is found with my search page. That is false because I can see that all the names are there in the column but on one line strung out left to right.

I believe that is so because when looking at values in the database it is just one continuous string or line. Which is what I would expect with a string along with loss of formatting no spaces

How can I make that column searchable for exact names first and last in that column and count how many?