I have the following codes as Item Variant codes:
ZMF21, ZMH20, ZMH21, ZMK20, ZMK21, ZMN20, ZMQ20, ZMV20, ZMZ20.
I'd like my JetReport to sort first by right (2), then by code. (i.e. the right (2) designate the fiscal year.). These variant codes are "externally determined", so I can't "rename" the variant codes.
How do you create a sort by specific characters within a string is the more universal question?