how to mask the phone number

kumarinfy · New User Joined: 30 Mar 2017 Posts: 2 Location: india

Hi ,
could you please help me to prepare a select query to mask the phone no
my requirement is to mask the phone no except last 4 digits
please note that phone nos are not fixed length
Table column(PHONE_NO) having values like below
94758365494
0438278475859574
8428746857733774443

expected output should be like below
xxxxxxx5494
xxxxxxxxxxxx9574
xxxxxxxxxxxxxxx4443

Thanks in advance

steve-myers · Posted: Mon Apr 03, 2017 5:50 pm

Do not post the same request in multiple forums.

It won't do you any good. For the most part the people willing to respond to your request visit the same forums, and if they see identical requests they will not respond to any of the requests.

This request has been in the beginners forum for nearly a week and there have been no responses. This means one of two things.

It is not possible. OR
It is facetious. If you do not want to display the phone number why is it in the data base to begin with?

It may be a better solution can be found in the agent displaying the contents of the data base

enrico-sorichetti · Posted: Mon Apr 03, 2017 6:09 pm

a telephone number is NOT a credit card number ...
showing the last four digits of a credit/debit card is a courtesy for the owner of the card

all over the world and for ages for telephone numbers it has been the other way around ...
mask the extension ( 3/4 digits )

irrelevant for 'private' numbers ,
most useful for business numbers where pass-trhu calls are not welcome

and remember ..

we reply on our own time and free of charge

if nobody replies it means that
nobody has an in depth knowledge of the topic
nobody is interested in answering
nobody likes You

GuyC · Posted: Mon Apr 03, 2017 6:19 pm

kumarinfy · New User Joined: 30 Mar 2017 Posts: 2 Location: india

Thank you so much