I imported data into SQL server using a CSV and now I'm trying to query through the data but unable to do so because SQL reads the values as 1 string.

**BookTitles** <-- DATA

ID : Title

1 : Cat in the hat

2 : Harry potter

3 : Lord of the Rings

4 : The Art of war

5 : Inside the cave

6: Incorporate

**For instance i cant use the query:** <-- QUERY

SELECT \* FROM BookTitles

WHERE Title = '%in%'

**I expect to get:** <-- EXPECTED

1 : Cat in the hat

5: Inside the cave

6: Incorporate

I am getting no results with the query above. Is there a way to use SQL to read all texts as individual words?