Hi,

I am struggling with case when for SQL in a view.

I have the following in a access query:

PMergeName: IIf([PPLastname]=[Lastname],[Title] & " & " & [PPTitle] & " " & [Lastname],[Title] & " " & [Lastname] & IIf(IsNull([PPLastname]),""," & " & [PPTitle] & " " & [PPLastname]))

How do I get this to a SQL Case when statement?