SQL Server replace characters in string

Question

I need to replace this number's 1234567891011 first and last four digits with stars.

How should I do it with replace function?

Andrey Korneyev · Accepted Answer · 2016-06-23 13:16:43Z

2

Use substring function instead of replace and concatenate stars with "middle" part of your string:

declare @str nvarchar(max)
select @str = '1234567891011'

select '****' + substring(@str, 5, len(@str) - 8) + '****'

Output:

****56789****

answered Jun 23, 2016 at 13:16

Andrey Korneyev

26.9k16 gold badges73 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Andy Thanks for reply, I will try solution and will let you know.!

Andy can you please explain syntax of substring, so I can further modify as per my requirement what if I need to replace middle 4 digits.?

@AkkiBhogte See msdn.microsoft.com/en-us/library/ms187748.aspx for reference on this function.