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?
Printable View
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')