Attribute Values

After entering an operator, you must enter the attribute value or another attribute as follows:

• Date Attribute: Single quotation mark, day of month, hyphen, three alpha characters for month, hyphen, four-digit year, and single quotation mark (that is, ‘dd-Mmm-yyyy’). Example: ‘18-May-2006’.
• Float Attribute: Series of decimal digits, decimal point, and optional digits. Example: 61.19.
• Integer Attribute: Series of decimal digits. Example: 60.
• String Attribute: Single quotation mark, case-sensitive system attribute value, and single quotation mark. Example: ‘Rural’.

Note:

If the attribute value contains an apostrophe, that single quote is duplicated when using the value in this context. For example, if the value to be filtered is O'Quinn for the string attribute of Claimant Name, the value ‘O’ ‘Quinn’ appears within the Filter Criteria area.

You can use the like SQL operator in filters (for example, ACCT_TYPE like ‘IRA%’).