Re: SQL Question???
>From: proberts@lynx.informix.com (Paul Roberts)
>Date: 18 Oct 1995 21:30:10 GMT
>Message-ID: <463rl2$ol4@news.informix.com
>
>In article <463ihb$q72@ixnews7.ix.netcom.com>,
>Mark Truty <marktrut@ix.netcom.com> wrote:
>>
>>I am trying to do a SQL query on a numeric field.
>>How do I query the last 2 numbers of a 5 digit field?
>>Example: number field = 54387 - I want to search for all records that
>>end in 87.
>>Thanks
>
>
>I really feel that we ought to be able to say:
>
> select *
> from tab1
> where column1 mod 100 = 87
You almost can:
SELECT * FROM TAB1
WHERE MOD(COLUMN1, 100) = 87;
Paul Kapp ----> PLKapp@aol.com -OR- plk@usorder.com