On Fri, Mar 4, 2016 at 4:23 PM, Igor Tandetnik <igor at tandetnik.org> wrote:
> On 3/4/2016 9:15 AM, Paul van Helden wrote: > >> So I have to detect integers in order to avoid the .0 >> > > WHERE CAST(A as integer) = 1 > > Not quite going to work either. I should have said the values are _nearly_ always integers, but they can be text (alphanumeric). So the general case is to compare anything to anything where there is a high likelihood of values being integers.