Hello,
I have a table where one of the fields is an alphanumeric string, something like the list below. Each character can have any value [0-9][A-Z].
1210I00358
1210I00359
1210I00360
1210I00361
1210I00362
1210I00363
1210I00364
1210I14200
1210J00000
121NFVR000
121NFVRB00
HS000D0000
HS00T40000
99HSNREC09
HS00L31102
HS00NNREC9
These values can be sort and in other tools I am able to apply a between two strings (SQL accepts this notation):
In SAP BO
However, in easymorph it isn’t possible to apply a between condition to text fields. There is any workaround that we can do in EM to manage these situations?
Thank you!