Column contains '@' is also handy (filters out some garbage as well)
-----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
