CONCAT and STUFF Functions in SQL Server 2012

  • Article

The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.


9,908 reads


It’s 2021, so why are you reading this?


If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....

Daily Coping 20 Jan 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

[Coping] Hidden Wounds


Through high school and college, I carried deep wounds due to what was going...

Read the latest Blogs


DAX how to rewrite this FILTER to CALCULATETABLE?

By ktflash

Ahoi,   i have been starting to look into DAX and there is something...

MYSQL ERROR - need desperate help

By Anth

Hi, Im having a problem with new players selecting a player class. Keep getting...

Execute As not reading system view

By pdanes

I have a stored procedure with the following: SELECT physical_name FROM sys.master_files Where physical_name...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers