Null value in string for param.

[jsulman]

Greetings,
I am creating a hyperlink in the Format Editor.
Based on a field being 'Other' I want to either pass the value of the field or a null value. The null value will then be passed as a parameter to a stored procedure so it cannot be sent with quotes. Does anybody know how I can do this? Here is the example.

if {P_CEAS8810.PROGRAM_CD} <> 'Other' then
{?URL_8811} & {SomeTable.SomeField}
else
{?URL_8811} & null


Thanks in advance.

jsulman