I have a VarChar field that stores Credit Card numbers, is there a way in a
SELECT statement to mask certain portions of the Credit Card Number?

For example:   1234-5678-9012 would show as xxxx-xxxx-9012

Thank you.

something simple like this?

declare @a varchar(20)
set @a = '1234-5678-9012'

select stuff(@a,1,9,'XXXX-XXXX')

Thank you.

Show quoteHide quote

The primary question, sincerely asked, is why are you taking the risk of
storing credit card numbers?

You could use the right() function and take only the last four numbers to
store -why store the 'xxxx-xxxx' part?.

But it seems that you really asking about a display mask. If you are
concerned about masking the data in a SELECT statement, then shouldn't you
really be asking if it is appropraite to be storing the data at all?

If you are using the last four digits for account verification, you could
store the last four digits in a one way hash and do a compare.

Show quoteHide quote

Marko
There are a few STRING function in the SQL Server like STUFF,SUBSTRING  to
do it for you



Show quoteHide quote

sql query - sp
How can I Rearrange my Data
Query taking long-long time
tring’
3 most-recent contact dates