Re: ORA-01722

> select asset, barcode from value
> where

        to_char(
                        to_date('17991231','yyyymmdd')        DATE
                        +
                        to_number(valdate),
NUMBER
                  'yyyymmdd')
        ='20000630';

That's no work because
        DATE+NUMBER isn't a DATE

What do you want to do?

--
"Soyez sport, Donnez votre Sang !"
Etablissement Français su Sang
0.801.150.150 ou 3614 Don du Sang
http://www.efs.sante.fr/