how to get select where not null to use an index

can't think of anything but

select * from mytable where varchar_field>= (select min(varchar_field) from mytable)

better ideas?

Thnx
.......
We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email