Partial symbol match on query

Hello everyone,
Is there an option to match a symbol partially on query (similar to SQL’s LIKE)?

E.g. Show records whose symbol in a certain column ends with USD?

Like is what you are looking for

https://code.kx.com/wiki/Reference/like

I think this should work: 

select from table where colname like “*USD”

Thank you Sean and Raveena!
I feel a bit embarrassed, I was looking in reference at where section.