I've got to clean up a credit card number column.
Is there a MS SQL function that would allow me to update all the values in that column to only have whatever the last 4 chars are?
I looked at some oc the TRIM and LENGTH functions, but trim seemed to be focused on trimming whitespace, and I'm not quite sure how to make length useful here.
Can someone please point the way?
Well, the new plan to just erase all the CC data has now landed on my desk, so I don't need an answer anymore, but I am still interested in how people would do this.