Case statement or how then?
Hi
I am in process of developing a package that will update late charges to customers. I am using this case statement as part of my select statment:
CASE
WHEN profile.profile_class_id = 4040
THEN profile.LATE_CHARGE_TERM_ID = 2001
WHEN profile.profile_class_id != 4040
THEN profile.LATE_CHARGE_TERM_ID = 5
ELSE null
END AS late_charge_term_id
This is used in a select script and my aim is to display the profile.LATE_CHARGE_TERM_ID as 2001 when the profile.profile_class_id = 4040 and to display the profile.LATE_CHARGE_TERM_ID as 5 when the profile.profile_class_id != 4040.