SQL function to change the last digit of a number to a letter
I have numbers that need to be changed in order to import into an AS400 database. I need to replace the last digit of the value to indicate whether it is a positive or negative number. EX: -1299 needs to be changed to 129R; 1299 needs to be changed to 129I. I have a list of corresponding letters for numbers but not sure how this should be written. Any suggestions?