Re: SQL Question???
Paul Roberts <proberts@lynx.informix.com> wrote:
>
>I really feel that we ought to be able to say:
>
> select *
> from tab1
> where column1 mod 100 = 87>
>But last time I looked, the "mod" function was available in 4GL but
>not in SQL.
Well, clearly I don't look often enough. It turns out that
select *
from tab1
where mod(column1,100) = 87
does what I want. I'm running I-SQL 4.11.UC1. Sorry for any
confusion caused!
- Paul