You're checking to see whether the substring from the second "-" to the end of the string ends with "CLP".
If the string contains one "-" character, or no "-" characters, you take the entire string.
Therefore, your test is equivalent to:
WHEN [Remarks] LIKE '%CLP'