Stuff() function – Transact SQL

STUFF() Function – Transact SQL The STUFF function deletes a specified length of characters and inserts a designated string at the specified starting point. Important note: STUFF function has a limitation if 4000 characters. The syntax is as follows: STUFF ( character_expression, start, length, character_expression ) character_expression: argument of this function is the character expression […]