Concat single Quote(') with String in SQL Server

Question

At mssql I want concat ' and 1 string

Example: Concat ('My name',''')

Ouput : My name'

Answer 1

Double-up the single quote character

Try this:

SELECT CONCAT('My name','''')

Ouput:

My name'

Answer 2

Or you can use '+':

select 'My Name'+''''