After a little more investigation, I found that you can use like with a numerical value provided that
you first create a string/text variable.
If you take the numeric field and concatenate a zero length ("") or empty string(" ") to it, you can use "like" with the new variable.
I found the code below to work in one of my queries.
Code:
SELECT Cabinet.Quantity, Cabinet.Cost, Cabinet.Component
, Cabinet.CabinetCode, [Cost] & "" AS A
FROM Cabinet
WHERE ((([Cost] & "") Like "2*"));
Table layout and some values.
Query result.