Which SQL tool considers one or more conditions, then returns a value as soon as a condition is met?

Correct
CASE considers one or more conditions, then returns a value as soon as a condition is met.