Operator

An Operator evaluates a condition of the data in a certain field with respect to a value. netFORUM uses operators on the Find and Query pages.

Here are some examples of Operators (in boldface):

  • Last Name Is Equal To Smith
  • Add Date Is Greater Than 11/10/2008
  • Is Member Is Checked
  • State Is In ( 'CA', 'OR', 'WA')
  • Organization Name Contains "Financial"

Depending on the Data Type of the field being evaluated, you will be presented with a list of different operators. A column of the Key data type, for example, will not allow for a greater than or less than operator, and a Check box will allow only for Is and Is Not checked. An alphanumeric field (that is, "string") will allow for the contains operator, but numeric and date fields will not.

Data Type Operator Option Definition
text Begins With

You can enter the first part of the text and netFORUM returns various records that fill in the last part.

Example: Enter "lu," choose "Begins with" and get records for LungCancer,

text Does Not Begin With  
text Contains  
text Does Not Contain  
text Ends With  
text Does Not End With  
text Is Equal To  
text Is Not Equal To  
text Greater Than  
text Greater Than or Equal To  
text Less Than  
text Less Than or Equal To  
text Sounds Like  
date Is Equal To  
date Is not Equal To  
date Greater Than  
date Greater Than or Equal to  
date Less Than  
date Less Than or Equal To  

Additionally, the Query page might offer more operators than the Find page because Queries allow you to create a Sub-Query.