System Parameters
'TL' LIKE Emulates Thoroughbred
   
Description Sets the LIKE Operator to use a simplified pattern match which emulates the behaviour of LIKE as used by applicationin written for use with Thoroughbred Basic.

The revised Throughbred-like pattern matching logic is:

  • "*" (Asterisk) in the mask stands for any number of characters including none
  • "?" in the mask will match any single character
  • [ ... ] will match any of the characters within the brackets.
    A range of charaacters may be speficied by including a dash as in A-Z which would match the characters A thru Z

To match any of the above escape characters ( * , ? or [ ) you need to include the character within square brackets as is:

  • [*] - Will match an asterisk
  • [?] - Will match a question mark
  • [[] - Will match a open square bracket
   
Default The default setting is Off meaning the LIKE operator will use the same pattern matching as MSK( ) function.
   
Example "ABCDEF" matches "*DEF", "ABC???", "*CD*" but not "ABC" or "?".
 
Thoroughbred is a registered trademark of Thoroughbred Software International, Inc