Searching numeric columns

The numeric value of the search string must equal the formatted numeric value of the column. The lengths (number of digits) of the search string and of the numeric column are not significant. Similarly, the data type of the numeric column is not significant. For example, a search string of 123 matches a DECIMAL column containing 00123, or a SMALLINT column containing 123. A search string of 123 does not match a DECIMAL or SMALLINT column containing 12300 (because the numeric values are different). An unsigned value in the string is considered to be positive.

Related references

• Finding data within specific columns

Related references

• CHANGE primary command
• EXCLUDE primary command
• FIND primary command