In vb and i think even in MS SQL server there is a ISNumeric function built in. I know there's no function like that in Oracle (9i), but i was thinking that there might be a logical way to determine if a field is Numeric or Not. Unfortunetly i can't use a stored procedure to do this either. So i'd have to do it in the sql statement itself.

Does anyone have an idea on how to do this?

Select Field1 from table_name
where field1 is NOT numeric

Thanks
Andy