I'm trying to figure out how to get this to work.
CASE WHEN {shipaddress1} IS NULL THEN {shipaddress2} // Works ELSE ( CASE WHEN {shipaddress1} IN 'Attn: ' THEN {shipaddress2} // Does not Work ELSE {shipaddress1} // It allway goes here END ) END If shipaddress1 has "Attn:" at the beginning, then I want to print shipaddress2 insteadThanks