Can we do "AND", "OR" statement for "LIKE"

Question

For example:

I want to find anything LIKE "A%" OR "%Z"

Answer 1

... WHERE col_name LIKE 'A%' OR col_name LIKE '%Z'