I am switching our Access queries to SQL views. How do I make this Access
97 "IF" statement a SQL 7 "criteria"?

FollowUp: IIf(IsNull([acct id]),"","Awaiting Follow Up")

Any help is very appreciated.