Thanks Segey - set ansi did the trick

>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