Phone Masking by sql server

-
declare @str varchar(50) ='43-2423-4234'
select
'XXX-XX-' + RIGHT(@str,4) as MaskedTaxNumber

Comments

Post a Comment

Popular posts from this blog

SECURING WEBAPI USING JSON WEB TOKEN (JWT) IN WEB API C#

-
Image
ref site :  http://www.decatechlabs.com/secure-webapi-using-jwt Step 1 : Step 2 : Step 3 : Step 4 : Now replace all code with below code using   Microsoft . IdentityModel . Tokens ; using   System ; using   System . Collections . Generic ; using   System . IdentityModel . Tokens ; using   System . IdentityModel . Tokens . Jwt ; using   System . IO ; using   System . Linq ; using   System . Net ; using   System . Net . Http ; using   System . Security . Cryptography . X509Certificates ; using   System . Threading ; using   System . Threading . Tasks ; using   System . Web ; namespace   WEBAPI_JWT_Authentication {      internal   class   TokenValidationHandler   :   DelegatingHandler      {          private   static   bool   TryRetrieveToken ...
Read more