Checking for numerics

Hi,

I have a PL/SQL program that needs to read a varchar field (which is = supposed to contain a dollar amount), do a to_number on the value, and = then do several calculations with the field. My problem is I've = discovered that there are some non-numeric characters in my column. = There are some records that are completely alpha, and there are some not = quite as offensive records that have the numbers prefixed w/ a dollar = sign ($). My question is, how can I check (prior to doing my to_number) = whether or not the field contains any non-numeric characters. Thanks in = advance.

Kelly Received on Sun Mar 05 2000 - 00:51:57 CST