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
?
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
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.