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?