Text - Concatenation Function

About

This a string function which allows to concatenate two different strings.

select year + '-' + week from DIM_WEEK
GO

select year || week from DIM_WEEK