On Sat, 2 Feb 2002, A. Van Hook wrote:
>
>
> I have a column (quantityonhand | character(15) | default '' )
> that I would like to use to perform simple math.
> I can't seem to get the syntax for casting and have tried various
> combinations of "select to_number(quantityonhand::text, '99G999D9S')".
> Can not get get past ERROR: Bad numeric input format ' '.
>
>
> Any help would be greatly appreciated....
You probably have a value in there which is not convertable to a numeric
(such as the default '').