>hi boris,
>
>OK for the view .
>I have a good result.
>
>here is the laatst code.
>
>i have still a little problem.
>
>The cast claus is not good ...?
>
>i put CAST( Cor9.IetatId AS I ) AS IetatId and when i haven't no ETATS for R1
>i have vart( v_resident.ietatid ) = "X" ?????
>
>it must be 'N' ?
>
>please see the attachment
>
>
>bernhart
Instead of CAST use NVL() or both:
CAST( NVL(Cor9.IetatId, 0) AS I ) ...
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.