How to fix this

Transact-SQL
1

image
image805×264 26.5 KB

when i add the highlighted column following error occurred how to fix this

2

Probably the column racenumber is an int. Try
select countrycode + ... + cast(Racenumber as nvarchar(50)) as ...

3

Use the CONCAT function instead of concatenation operators.