string to number conversion

From: Daniel Nigrin <nigrin_d_at_a1.tch.harvard.edu>
Date: Fri, 22 Jan 1999 15:18:43 -0500
Message-ID: <36A8DD23.329B835B@a1.tch.harvard.edu>

I have a large Oracle 7.3.x table that contains a varchar(2) column (called "RESULT"); some values contain solely numeric data, others have text data.

I would like to return the rows for which RESULT < (a number).

What is the most efficient way to strip out those rows which contain text in the RESULT field, prior to doing the above operation, which would give an Oracle error if it encountered a text row?

TIA,
Dan Received on Fri Jan 22 1999 - 14:18:43 CST