Here are screenshots to emphasize the two methods. And, it DOES directly answer the Subject Line of the OP's question. I need to make a SWITCH statement that says this: SWITCH ( ItemNumber, if the part number contains '3AB' then say 'GroupA', if the part number contains 'BAG' then say 'GroupB', else say 'XXX') Solved Go to Solution. So we will use Parts '123ABC' and '897BAG'. CONTAINS is a SQL Server function to search for a word or phrase in one or more text columns using precise or fuzzy matching. Yes, strictly speaking, this does not answer the OP's question about where the registry entry is, and about using the newer Settings-based interface, but it may offer a simpler solution that more people (including myself) are looking for when they land on this question, and that may not be obvious on a quick reading of previous answers (even though some do explicitly mention Control Panel). Each part of the 'Part Number' means something different. However, the older 'Control Panel' interface (which is still easily available in Windows 10) does allow removal of an errant entry.

The query scans the values in the column, which is slower than looking up a term in a term index. contains searches for characters rather than terms of three or more characters.

When there is a problem uninstalling an application, the newer 'Settings' interface does not currently provide the option to remove the entry. Filters a record set for data that doesn't include a case-sensitive string.

I'm adding this answer because, judging from some of the comments, it is not clear to all that Windows 10 offers two separate interfaces for uninstalling programs, and that editing the registry is generally not required to remove an entry from the programs list.

Case contains items instal