SET ANSI ON or change LEFT() TO PADR() and it'll be included.
>I think I have become brain dead and need help. Given the following code:
>
>
> Select * From deposits Where ! Empty(sif_no) And ;
> Between (dep_date,ldbegindate,ldenddate) ;
> AND LEFT(ALLTRIM(inv_no),2) <> "WO" AND ;
> ! inlist(Left(Alltrim(inv_no),3),"RTN","COL","REF");
> Order By dep_no Into cursor deposit_extract
>
>
>
>If inv_no is blank it doesn't get included. I am looking to exclude only those four type of invoice number entries in the code.
>
>There probably is a simple answer but I just don't see it.
>
>Thanks
>Gaylen
--sb--