>When comparing data with a condition you have to use the == to get an exact match with characters. It is often nice to use the INLIST function to list multiple values possible in a condition. Say "7", "25", and "39" are possible values and you don't use the ==, then something like "75" would be true even when you don't want it to be. You could write out each condition with the == and be OK, but is there any way to apply the == (exact match) condition while using an INLIST function?

Only by using SET EXACT ON setting or by specifing the the values padr(ed) to the exact length of the field.