Hi Nick,If I understand your requirement correctly, your var htmlBlock1
depends upon ( targetData.christmas == 1 ) condition.You can try below
in your delivery:<%var htmlBlock1 = ' ' ;if ( targetData.christmas == 1
) { var htmlBlock1 =
} %>-- HTML Content --You can call
this variable in the HTML content using <%= htmlBlock1 %>Hope this
helps.Thanks,Anita
Hello DarrenBiz.Here is the SQL script that we created:DROP FUNCTION IF
EXISTS convertToVarchar(parmValue text);CREATE OR REPLACE FUNCTION
convertToVarchar(parmValue text)RETURNS VARCHAR AS 'DECLARE v_var_value
VARCHAR DEFAULT null;BEGIN v_var_value := parmValue::TEXT; RETURN
v_var_value;END;' LANGUAGE plpgsql;Best regards,Anne-Sophie
