比较字符串结尾的最佳方法是使用RIGHT，LIKE还是其他？

I need to compare the end of strings against a list of possible ending in a stored procedure. It will be called a lot and there are around 10-15 candidate endings. At this point a code-only solution is preferable to creating tables dedicated to this. Something that would be like:I need to compare the end of strings against a