Click here to Skip to main content
15,897,291 members
Articles / Database Development / SQL Server
Tip/Trick

Selective masking in SQL server 2005

Rate me:
Please Sign up or sign in to vote.
4.00/5 (1 vote)
5 Jan 2012CPOL 12.6K   1  
Masking selected characters in SQL, hiding few characters
SQL
--Mask all but show only last 3 digits of the phone number
DECLARE @PhoneNo varchar(10), @Mask varchar(10)
SELECT @PhoneNo = '1234567890', @Mask = 'XXXXXXXXXX' 

SELECT @PhoneNo as 'Phone No', replace(@PhoneNo, substring(@PhoneNo, 1, len(@PhoneNo) - 3), 
substring(@Mask, 1, len(@PhoneNo) - 3)) as 'MaskedPhoneNumber'

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior) TATA Communications
India India
I have a total experience of around 5 years out of which 4 years in MS technologies. I have a passion towards coding.

Comments and Discussions

 
-- There are no messages in this forum --