Dan Another way would be to search for not like '[EMAIL PROTECTED]' may help since all valid emails should have that symbol.
Mike D **************************************** Educational Directories Unlimited, Inc. Michael Dittbrenner Programmer http://www.StudyAbroad.com http://www.GradSchools.com A service of EDU, Inc... http://www.EDUdirectories.com A partner of EDU Internet Strategies: http://www.EDUInternetStrategies.com/ [Phone] 610-499-9200 [Fax] 610-499-9205 [E-mail] [EMAIL PROTECTED] or [EMAIL PROTECTED] -----Original Message----- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 10:09 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Search on Email What would be the best way to do a search to bring back only the records where their was an email address. I can't use null for some reason they seem to be blank not null. SQL 2000 witango 5 -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Cell: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com "When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry." ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
