Search for an empty string - in MSSQL a null & an empty string are two different things. Depending on your Inserts, you may need to check for both. (Looking for an empty string won't find a null, and looking for a null won't find an empty string.)
Try this: table.emailaddr != '' jamileh > -----Original Message----- > From: Dan Stein [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 16, 2004 9: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
