To Execute Dynamic SQL command in SQL Server

DECLARE @Cmd varchar(1000)
DECLARE @TagNo varchar(75)
SET @TagNo = '''XI-208B'''
SET @Cmd = 'SELECT * from tblAmatya where TagNo = ' + @TagNo
EXEC (@Cmd )