SQL Conditional column data return in a select statement
Solution 1:
You didn't mention your DBMS but a searched CASE
statement works in all major DBMS's I know off.
SELECT ID
, CASE WHEN WorkStream = 'Internal'
THEN WorkStream
ELSE Assignee
END AS Assignee
, Workstream
FROM assignees
Reference: MSDN
CASE
Evaluates a list of conditions and returns one of multiple possible result expressions.
Solution 2:
SELECT ID,
CASE WorkStream WHEN 'Internal' THEN 'INTERNAL' ELSE Assignee as Assignee, WorkStream from assignees
I hope this help.