The "If... Then" Layout.

[RossP]

Hi, Everybody!

I

[-Queue-]

Sure, Case( not IsEmpty(City) and not IsEmpty(State), "," ) will work.

[RossP]

Awesome, Queue-man.

It worked. I'm not sure exactly how, but it worked. I guess I need to final figure out how to write real calculations.

I've always been under the impression that when you select a specific "operator" in the calculation window, FM Pro shows you a specific syntax which you have to follow.

In the case of "CASE" this is:

Case ( test1 , result1 [ , test2 , result2 , default result]... )

But you're Case function doesn't seem to follow this syntax. I think.

Alas, I am a musician by trade. I was never good a logic.

thanks again!

[benk]

"But you're Case function doesn't seem to follow this syntax. "

It in fact does follow syntax, it just appears that it doesn't because the calculation only includes one case,

Case( not IsEmpty(City) and not IsEmpty(State), "," [ , test2 , result2 , default result]... )

and if statment should work as well

if( not IsEmpty(City) and not IsEmpty(State),",",""

[bruceR]

I think more recent convention in mailings is to just eliminate the comma.