I have 2 types of invoices this is looking at evidently. One of them doesn't even have a SPCD field at all tied anywhere. I need the program to look at the SPCD field first though because the majority of the records have this listed first (Zipcode). How can I tell the program to skip over the SPCD if there is no record and go to the CMASSH.CS_PCD?

IF (TRIM({MNBDM.BM_SPCD}))<>"" AND not isnull({MNBDM.BM_SPCD}) then
{MNBDM.BM_SPCD} else
{CMASSH.CS_PCD}