If it is a varchar2 column and you have valid data in this column, the query should return all the rows.

Or, are you trying to filter out invalid data ?

What are you trying to accomplish ?