So I have a query that brings in a column like the example below
Column A |
---|
5.3 |
8.4 |
7.3% |
2.1 |
2.2 |
6.4 |
9.1 |
8.8 |
I want to exclude the value that has a percentage sign (%) on the end. However, I’m not sure how to do this in Oracle SQL since the % sign is used as the wildcard in strings.
Does anyone know of a way I can exclude these values?
Thank you!
I’ve tried using a couple different variations of LIKE and IN conditions but haven’t been able to figure anything out.