Unanswered: use of an IF statement in SQL Server or something similar
I have a table with the following Fields:
what I want to achieve is the following;
I have ten records in this table. All ten records have First and Last Names, and two of the ten records also have nicknames (meaning eight of them are NULL).
now I want to develop a query where, with an outputted field, where if the nickname is NOT NULL, then the output field (in the query) shows their first and last name. HOWEVER, if a record has a nickname, then in that same outputted field, the nickname is displayed instead of the first and last name.
I know it sounds very long winded, but I am in some serious need of help with this issue. how can I resolve this?