Select to Delete conversion

Merge [Profile] TAB1 
Using (
SELECT [Col1] AS [ID],[Col2] AS [FileID]  FROM [SupData] 
WHERE UPPER([DSet]) = N'TEST'
) as TAB2 
ON TAB1.[ID]=TAB2.[ID] AND TAB1.[FileID] = TAB2.[FileID]
WHen Matched
 then Delete;