Here is an example of the computed column (incase you need it)

USE tempdb

GO

CREATE TABLE TableA

(

ColumnA VARCHAR(5),

ColumnB VARCHAR(5),

ColumnC AS ((ColumnA+'-')+ColumnB)

)

INSERT INTO TableA

(ColumnA,ColumnB)

VALUES

('Hello','World')

SELECT ColumnA,

ColumnB,

ColumnC

FROM TableA

DROP TABLE TableA