On 3/4/2016 9:29 AM, Paul van Helden wrote:
> 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.
CAST('anything' as integer) produces 0. Would that be sufficient?
--
Igor Tandetnik
