@%1-3 are variables that's replaced by our system. So far so good. Here's the tricky part. A new requirement is to send a part of the JobNo (@%2), to another field as well, that we might call LineNo.
In two tables I have a field that contains 7 pieces of data (using a pipe as the delimiter) in one field. I want to explode this out into 7 seperate fields. The format is something like ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results