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