How to get multiple records in one column?

Suppose You need to get multiple records in a single variable or column

Decalre @var Nvarchar(1000)

SELECT @var = IFNULL(@var,'') + var1 + var2
FROM table

In this way you can get multiple records in a single variable......

Happy Coding :P