is it possible to right a query which counts the length size of column input or the datatype of column input

eg select * from items
where itemID length = 1
or
where itemID = 0 - 9