>Well, the data type is numeric.

You cannot compare a numerich value to a string. You either have to conver a numerich value to a string as Cetin suggested or find some other way. Keep in mind that

AND trans(Hardware.host) like '%100%';

isn't Rushmore optimizable so the query could be slow on big table.