Hi I fought this monster too :-b To some databases
'' is not equal to NULL one way is to create customer field and use len() len(column.name) > 0 Ben Johansen - http://www.pcforge.com Authorized Witango & MDaemon Reseller Available for Witango Developement -----Original Message----- From: Witty Tango [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 11:01 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Fw: Search actions and Null fields Hi. I am having problem with Search actions on SQl server 2000. I have a resume database with lots of text fields. I want to generate a report of users who have at least one field in the resume filled-up. And exclude the ones that nothing in their resume. When I choose "Is not Null", somehow it does not understand it. If I go and make an entry in a field, save it. Then delete it. Now it understands the "Is not Null". Any ideas? Any better ways to do it? I tried using != '' It gives me an error message saying that I cannot do that with text fields. Help me guys. - Witty Tango. ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf