problem with LIKE predicate and wildcards

The only way I have been able to get the LIKE predicate to work at all
is like this:

SELECT * FROM profiles WHERE lastname LIKE 'Marin%';

returns rows with lastname starting with 'Marin'

I cannot seem to say:
LIKE '%aring'
LIKE 'Ma%ing'
LIKE '_aring'

Specifically I need to search for rows like this:

SELECT id FROM profiles WHERE id LIKE '_____001';

should return:
TAMP-001
DALL-001
VANC-001

Can someone PLEASE help me. I'm desparate! Thanks.

-Steve Maring
smaring(at)gte-es(dot)com
Tampa, FL USA