Update rules

I need to write a routine in the Update Rules for a field. The rule will be getting the values from a P table.

As part of the key matching for the lookup. I need to put IF infront of the field. Therefore:

Select * from table where

IF<ptablekey> = IF<commkey>

Could someone provide me with the syntax. Thanks