Replace the caret with any character that you know doesn't exist in your field and use that character to specify the pattern. The replacement character could also be a non printing character or any character in the UTF-8 code set.
You could even use a non-standard caret symbol as a temporary replacement for matching (if you risk it):
If I understood you issue, you are dealing with the folloing column: [LINE_ITEM_ADJUSTMENTS], it contains line adjustment codes separated by carrots (^), which is fine; the information coming in this variable could be like:
The sample contains the codes without leading-trailing carrots and the carrot itself is a wildcard in the wildmatch function.
It is better to get-rid of the carrots, I will suggest the pipe '|' character (it is up to you based on the data), the same process replacing the carrots with pipes should insert the leading and trailing pipes, something like this:
'|' & Replace(LINE_ITEM_ADJUSTMENTS, '^', '|') & '|' as workText
The output of the previous function transform your line item adjustments into
After replacing carrots with pipes, your WildMatch will resolve these search.
Now, this approach will fail when the LINE_ITEM_ADJUSTMENTS contains the codes CO-24 and CO-242; but if you implement the PICK function suggested in your other thread, you may not have any issue at all !!!
Let us know if this suggestion is in the right track, and if your data is unlikely to fail with the condition shown:
The meaning of the carrot in wild search is 'the field is starting with the search value'
Hope this helps,
Arnaldo Sandoval A journey of a thousand miles begins with a single step.