How to replace six chracters from middle from any string ??

[Abhishek kumar121]

Hi, There is column for mobile number in my table whose data type is string. I have to replace six character from middle with star(*) from the string of 10 characters. For example The Contact number is 9334459875 I have to display it as follows 93******75 first two characters and last two characters only.

[Lost User]

SELECT LEFT(PhoneNumber, 2) + '******' + RIGHT(PhoneNumber, 2)
FROM AdventureWorks.Person.PersonPhone

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[PIEBALDconsult]

If SQL Server: PRINT STUFF( '9334459875' , 3 , 6 , '******' )

[Kiran Upadhyay]

SELECT STUFF('9334459875',3,6,'******')