Deletes a portion of a string and inserts a new string.
Syntax
STUFF(str, start, len, newstr)Example
Enter values below to update the example in real time.
resident_no→masked_no→members→-- 주민번호 마스킹
SELECT STUFF(resident_no, 8, 6, '******') AS masked_no
FROM members;