>so if i want to know wich line are empty , how can i do a select that will return the specific line
>
>
>select * from arinv where invdte = ????
>
>thanks
select * from arinv where EMPTY(invdte)
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst