How would i use the substring function to get values starting from the right 4 values'
example 874121001 should equal 87412
2151001 = 215
if i use substring (874121001 , 1,5) that would work however
if a vaule within the column is like substring(2151001 , 1,5) would return 01 which is not correct it should be 215