Try below query
DECLARE @Table TABLE (Id INT, Name VARCHAR(200))
INSERT @Table VALUES (1,'a')
INSERT @Table VALUES (1,'b')
INSERT @Table VALUES (2,'c')
DECLARE @test AS VARCHAR(MAX) = 'test'
DECLARE @ID INT = 1
SELECT CASE WHEN (SELECT COUNT(DISTINCT(Name)) FROM @Table WHERE ID=@ID) > 1 THEN @test + '*' ELSE @test END