Now we need to split this field into 5 new fields, named Srllno1 to Srllno5, with values of the 1st to 4th string and the 5th to last string after splitting the original field. Fill in null when the ...
@%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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results