newbie - wildcard search

[ericksoda]

I have been reading the online documentatin but have not been able to make this work.

I have a table with a SEARCHNAME column which has uppercase lastname, firstname middlename, for example:
"LASTNAME, FIRSTNAME M"
"LANDRY, FILBERT W"

I want to search based on partial last and first names.

I tried this query:
SELECT * FROM PERSON WHERE SEARCHNAME LIKE 'LA%,FI%';

but it returns no rows. How do I make this wildcard search?

Thanks,

David

 

[lewisp]

In your examples you have a space after the comma, but in your query you have omitted it.

 

[ericksoda]

Doh! Thanks! I can't believe it was that easy.

David