Jesse,
If you search in the "old" OpenQM docs at OpenQM on "widlcard", it brings up a list of possibilities, the first of which is the "EQ" entry.
It states:
Pick Style Wildcards
If the PICK.WILDCARD option is enabled (see the OPTION command) and the value item is a literal value, the interpretation is extended to include use of Pick style wildcard characters:
•A [ character at the start of the value replaces any number of leading characters. It is equivalent to the … action of the LIKE operator.
•A ] character at the end of the value replaces any number of trailing characters. It is equivalent to the … action of the LIKE operator.
•A ^ character within the value replaces a single character. It is equivalent to the 1X action of the LIKE operator.
See also here - EQ (rocketsoftware.com)
LIKE (rocketsoftware.com)
Does that help?
Mike
------------------------------
Mike Street
Technical Support Engineer
Rocket Internal - All Brands
------------------------------
Original Message:
Sent: 06-30-2023 09:37
From: Jesse Tillia
Subject: Wildcard characters in select statements
we are working on D3 to QM conversion.
The client had a number of select statements that use wildcards.
we already know, and are converting to "pattern matching" from QM.
The square brackets all still work. Is there any characters to use similar to D3 with part.nbr = "A^^3^^"
The up carrot was a wild card character for a single character.
I have been searching the online docs, but have not found it. (like most docs, if you know what you are searching for, it is easy)
------------------------------
Jesse Tillia
Rocket Forum Shared Account
------------------------------