Re: Problem with using NVL Function ins SQL

Użytkownik paul.izzo_at_mosca-ag.com napisał:

> LPAD(TO_CHAR(TO_NUMBER(konten_nr)),8,'0'),
>
> I then changed the line to the following: [COLOR=Blue](The script ran
> but now I notice that the formatting is wrong)[/COLOR]
>
> LPAD(TO_NUMBER(LTRIM(konten_nr)),8,'0'),
>
> I attempted to use the NVL function that will return a value when
> there is nothing in the column field but it doesn't work. Does anyone
> know what I'm doing wrong?
>
>
> LPAD(NVL(TO_CHAR(TO_NUMBER(konten_nr),'FM999999999'),'0'),8,'0'),
>

Could You be more specific?
What Program is used to generate ascii output? What means [COLOR=Blue] ?

NVL() should resolve this problem.
Is that Oracle Database ?

How looks that script? Please post header of that script.

-- 
Noel