SQL: How to query money field for only values with non-zero in the 'cents' portion?
Posted on 2015-01-23
My donation table looks like this:
... other fields ...
I wish to run a report selecting ONLY rows where the donation amount has a non-zero in the 'cents' portion of the field. For example, if a row had a donation of 12.66, then I would want to select that row. But if the row had a donation of 12.60, then I would skip that row.
Is such a query even possible? I've been googling with no luck.