Search for an integer ending in '9' using SQL

Question

As part of a query I need to search for a nine digit number where the last number is 9.

How would I do such a query?

Answer 1

MOD for % in informix
and between for 9 digits

select colname 
from tablename 
where 
    MOD(colname, 10) = 9
and colname between 100000000 and 999999999