How to use lookup function ignoring first 4 chars and do the match
I am using below function and it works fine but i want to match the value ignoring the first 4 chars as they are only added to sort the data.
My table has following values
w ^Ens.LookupTable("EMRName","0002EMRNameA") this works
But i want to use something like that
w ^(Ens.LookupTable("EMRName","%EMRNameA") this doesnt works