Does SQL have an IF THEN function?

Does SQL have an IF THEN function?