Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sequal select statement and blank field
Message
From
19/06/2003 18:00:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Sequal select statement and blank field
Miscellaneous
Thread ID:
00801967
Message ID:
00801967
Views:
33
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
Next
Reply
Map
View

Click here to load this message in the networking platform