>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.
If it's not broken, fix it until it is.
My Blog