I have ,for example, this table in a Microsoft Access database:
select * from table where numberfield like "%9"
That sound a little fishy.. are you sure you can use that query? Don't know about Access but almost any other DBMS allows it.
If it really doesn't work, you can do this:
select * from table where STR(numberfield) like "*9"
EDIT: Maybe it didn't work because you used
% which is used with
* in Access .