I'm not sure if this answers your question ...

SELECT * FROM table WHERE column LIKE '1%'

This query will find all the rows where the value in column starts with a one (1).

-Mike