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