Sau:

SELECT ProductID, [Name] FROM Product

WHERE CONTAINS([Name], '("n*" AND NOT "nn*") OR "n^n*"')