Re: SQL Question???
Actually, I've tried the MOD function in my database (version 6.0.UC1)
and it works fine. That is, the select:
SELECT *
FROM test_tbl
WHERE MOD(test_col, 100) = 87;
returned as expected. Give it a try!
--Craig (craig@chemistry.utah.edu)
>
>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.
>