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@gte-es.com
Tampa, FL USA