Previous Topic Next topic Print topic


X127: Pattern matching allowed on character fields only.

LIKE searches, which use wild card pattern matching, can only be performed on character fields. You may perform range searches on other field types, including date and time. If you want to search a date field by day, month, or year, use XDAY, XMONTH or XYEAR, respectively.

Previous Topic Next topic Print topic