need your help to create a query for I have a column called 'A' with 10 digits in length
I also have a column called 'B'
I want to mask column A and replace the first 5 digits with column B.
Post masking :
SAM 67890 (with 2 spaces)