Bernie, Never test for NULL with an equal sign operator. Test for NULL with "IS NULL" or "IS NOT NULL."
IF mfr IS NOT NULL THEN PRINT areport ENDIF To be doubly sure, in case mfr might have had a single space put in it, or might truly be null, test this way: IF mfr IS NOT NULL AND mfr <> " " THEN PRINT areport ENDIF It's time to start converting to the SQL standard of single quotes, Bernie. R:Base 7.0 will make it worth the time you spend! Bill (Yet another person who was at the latest R:Base 7.0 seminar, who is amazed and anxious for the world to see this new wonderful product.) On Mon, 23 Sep 2002 14:45:41 -0400, Bernard Lis wrote: >if null is set = " " >and mfr = "xxx" >if mfr <> " " then ; print areport ; endif >nothing prints >if null is set = -0- >if mfr <> " " then ; print areport ; endif >prints the report but null fields show -0-, which is undesirable. >so, any suggestions? ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
