>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 invdte IS NULL
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.