|
Query - Case Sensitivity and Absolute Value |
  
|
|
Query - Case Sensitivity and Absolute Value |
|
When enabling case sensitive matching we are telling the computer that we DO CARE and that it DOES matter if the text stored in our database is in UPPER or LOWER case. Truth of the matter is, we usually don't care and would normally leave this option unchecked.
When Case Sensitive Matching is Enabled (checked)
Smith and SMITH are not the same.
When Case Sensitive Matching is Not Enabled (unchecked)
Smith and SMITH are considered to be the same.
Absolute value is always the positive value of a number. When enabling comparisons using absolute value, we are telling the database that we DO NOT care and it DOES NOT matter if the field's value is negative or positive. Truth of the matter is, we usually do care and would normally leave this option unchecked.
When Compare Using Absolute Value is Enabled (checked)
-100 is considered to be 100.
When Compare Using Absolute Value is Not Enabled (unchecked)
-100 is considered to be -100 (as it normally would be)
Page url: http://www.encouragersoftware.com/help/index.html?case_sensitivity_and_absolute_.htm