But from my scenario I dont

> think I am getting a null value after all. because in table b, records
> can't be save if there is no value in requestqty.
>
> thank a lot for your kind and patience.
>

james_027,
can't save if there is no value...???
do you actually test for null too here? or just no value?
what is the method of not saving when there is no value?
Have you doen a
select count(*) from table where value is null
? to see if in fact there are null values there?

Alan