Thread: Covert Iif statement into SQL
2014-04-04, 01:44 #1
- Join Date
- Mar 2005
- Leicestershire, United Kingdom
- Thanked 0 Times in 0 Posts
Covert Iif statement into SQL
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?Best Regards,
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!