How to change first 6 digits to an X

[dndaughtery]

I need to mask account numbers. I have been asked to mask the first 6 digits to "X".

Example:

Acct number before mask: 123456789

After mask: XXXXXX789

How can this be done?

 

[SQLDenis]

declare @v varchar(10)
select @v ='123456789'

select 'XXXXXX' + substring(@v,7,(len(@v) -6))

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLDenis]

so just use this, assuming AccountNumber is your field name

select 'XXXXXX' + substring(AccountNumber,7,(len(AccountNumber) -6)) from table

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLDenis]

of course if all your fields are 9 digits you can use 'XXXXXX' + right(field,3)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[dndaughtery]

Darn! Why didn't I think of that? Thx.