I need to report on sales orders where the ship date (translated to day of the week) does not match the list of delivery days in a custom field we created on the customer record. I'm having a hard time with the sql to say 'if ship date day of week is not in custom field', I've tried several things but can't get it to work. For example, Case When INITCAP(TO_CHAR ({shipdate}, 'DAY')) NOT IN ({custbody_vgw_so_del_days}) then 1 else 0 end