SELECT ARTIST
FROM L_PRODUCT
WHERE ARTIST IN ('MATT MCANDREW')

MATT MCANDREW
MATT MCANDREW
MATT MCANDREW

SELECT DISTINCT ARTIST
FROM L_PRODUCT
WHERE ARTIST IN ('MATT MCANDREW')

Matt McAndrew

SELECT DISTINCT ARTIST COLLATE Latin1_General_CS_AS
FROM L_PRODUCT
WHERE ARTIST IN ('MATT MCANDREW')

MATT MCANDREW