Record Select

Hi All,

I have a column in a table that has the data that looks like this:

1 1234 somewhere street
2 45a main rd
3 124A work ave
4 new street

I need to pull records 2 and 3 only. Any ideas?

What is the criteria for selecting records 2 or 3, is it the first character in the column?

select * from table1
where substr(col1,1,1) in ('2','3')