If and Multiple AND's

[#1]

Hi,

      I have 10 fileds with blank  and if all are blank then pass else fail.

I wrote an expression like this in straight table which is not showing  any result:

if(if(STR_SUPPL1=' 'and STR_SUPPL2=' 'and STR_SUPPL3=' ' and PO_BOX_LOC='' and PO_BOX_NUM='' and
    PO_BOX_REG=''and PO_BOX_CTY='' and ROOMNUMBER='' and FLOOR='','PASS'),'FAIL')

And  tried same with isnull().

anybody pls help me.

Thanks

[sasiparupudi1]

if ((len(STR_SUPPL1)=0 and len(STR_SUPPL2)=0 and len(STR_SUPPL3)=0 and len(PO_BOX_LOC)=0 and len(PO_BOX_NUM)=0 and len(PO_BOX_REG)=0 and len(PO_BOX_CTY)=0 and len(ROOMNUMBER)=0 and len(FLOOR)=0),'PASS','FAIL')