I have a large database and need to find records with a particular word in the title.

In the SQL pane I used:

SELECT *
FROM MyTable
WHERE (BookTitle = 'sunrise')

Now, this gives me one book with only "Sunrise" as the title. But I want all titles with "Sunrise" in them. How do I change my query to find them?

Thanks in advance.

SELECT * FROM MyTable WHERE BookTitle LIKE '%sunrise%'

Try that.

Perfect! Thanks a million. I'm writing this one down and pasting it on my monitor!! <GRIN>

Glad you like it.