Concatenate Fields In Sql. If we concatenate string using the plus ( +) operator, we need to use sql convert function to convert data types. The following statement concatenates two string values:

We can use sql convert function as well without converting the appropriate data type. Select concat (yourcolumnname1, ' ',yourcolumnname2) as anyvariablename from yourtablename; Take a look at an example below to understand how it works.