SELECT CustomerID, FirstName, LastName, Company, PhoneHome, PhoneWork
FROM MasterAccounts
WHERE maExpireDate IS NULL
:-) Hope that helps...
Nathan Haywood
-----Original Message-----
From: PowerNet [mailto:psc5@powersupply.net]
Sent: Saturday, February 26, 2000 10:55 AM
To: emerald@iea-software.com
Subject: [Emerald] QUERY HELP!
Can someone help me with a query to see what customers have with a blank
expire date?
Thanks,
John
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart