How to use Replicate function for masking in SQL?

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*********

Not Null check on LEFT function with T-SQL

DATEADD Function in SQL

Replace duplicate spaces with a single space in SQL

Get the row number "x" from SQL

Post Views: 75