RE: [Emerald] QUERY HELP!

Nathan Haywood ( nhaywood@whro.org )
Sat, 26 Feb 2000 13:10:04 -0500

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: PowerNet: "[Emerald] QUERY HELP!"
Next message: PowerNet: "RE: [Emerald] QUERY HELP!"
Maybe in reply to: PowerNet: "[Emerald] QUERY HELP!"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald] QUERY HELP!"

You mean, like...

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

Previous message: PowerNet: "[Emerald] QUERY HELP!"
Next message: PowerNet: "RE: [Emerald] QUERY HELP!"
Maybe in reply to: PowerNet: "[Emerald] QUERY HELP!"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald] QUERY HELP!"