Masking

Question

Masking

vino5786

Right there with Babe

Points: 743
More actions
December 9, 2011 at 11:22 pm

#249403

Hi,
In a Blob column we storing mail contents, comments, documents etc.,
That content contains credit card number, While sending it to screen we need to mask that 16 digit credit number alone.
Is there any way to do this SQL Server.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 1

The encryption feature is available in SQL Server. But it’s a BLOB & you want to encrypt a portion of it, I would recommend you to do this encryption on application side.

Jeff Moden SSC Guru Points: 1004307 More actions · Answer 2

vino5786 (12/9/2011)
Hi,
In a Blob column we storing mail contents, comments, documents etc.,
That content contains credit card number, While sending it to screen we need to mask that 16 digit credit number alone.
Is there any way to do this SQL Server.

Gosh... why are you storing this all in one Blob column? These types of things should be stored in a normalized fashion and display as separate lists of things on the screen.

When you say you need to "mask that 15 digiit credit number alone", what do you really mean? Do you mean you want to display it as a separate field on the screen or do you mean you want to blot out the credit card number?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

vino5786 Right there with Babe Points: 743 More actions · Answer 3

Thanks for your reply. I mean to mask 15 digit number with xxxxx.