we have full ss# in our employee master and now HR is wanting to stip the first 5 digits off. Trying:
update clocfilemh/ckempeff set eessno =
getting "Character in CAST argument not valid."
When I try select eessno, decimal(substr(char(eessno),6,4),4,0) getting "column sel0002 contains replacement character +."
How can I convert a field to the last 4 digits?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!