This content has been marked as final. Show 4 replies
I currently have this STRM1 data, where 1220 represents term 2 of year 2012, 1420 represents term 2 of year 2014 and so on. What i want to be able to do is to get the first 2 characters of the field and add a '20' in front to display as year.
get first 2 characters from STRM1 , 1220, '12', will be retrieved
Then add a '20' in-front , to show as 2012 in a new column
Anyone can help?
Thank you for your time.