How can I merge this query so that it returns only one column?

I have the following table:

Player Name Nationality
Romelu Lukaku   Beligian
Christian Pulisic   American
Kai Havertz German
Masoun Mount    British
Reece James British
Edouard Mendy   French
N'Golo Kante    French
Hakim Ziyech    Morrocan
Timo Werner German
Thiago Silva    Brazilian
Ross Barkley    British

I typed the following query:

SELECT REPLACE([Player Name], 'Reece', 'John'),
 REPLACE([Player Name], 'Christian', 'Chris') FROM Players

The query above returns two columns rather than just one. How can I make the query one so that only one column gets returned?.

>Solution :

You can use UNION tojoin rows vertically

SELECT REPLACE([Player Name], 'Reece', 'John') as name FROM Players
UNION
SELECT REPLACE([Player Name], 'Christian', 'Chris') FROM Players