I have a column 'SSN', it needs to be masked partially.
ie., it shouldn't display the entire number instead it should display as
1) xxxxx1234 to a certain group
2) 453221234 to another group.
Can you please help?
any ideas would be really helpful
'XXXXX'|| SUBSTRING('SSN' FROM LENGTH(SSN) FOR -3). Try this one and let me know if this works for you or not..