Bits of .NET

You can use SQL “Replicate” command to mask the data. Below code shows how to make it:

CREATE TABLE FOOTBALL_CLUBS
(
ID INT IDENTITY(1,1),
CLUB_NAME NVARCHAR(100) 
)

INSERT INTO FOOTBALL_CLUBS
(N'GALATASARAY')

SELECT CLUB_NAME AS [Club Name], LEFT(CLUB_NAME, 2) + REPLICATE('*', LEN(CLUB_NAME)-2) AS [Masked Club Name] FROM FOOTBALL_CLUBS

OUTPUT:
Club Name          Masked Club Name
===================================
GALATASARAY        GA*********