I hope someone can help with a basic question involving a simple select statement.
In my view, I want to conditionally concatenate the output two values in a single derived column. I know this should be simple but I can't find any reference for the basic sytax that will work in the query grid of Enterprise Manager.
EXAMPLE:
firstName = John
firstName2 = Duke
concatenatedName = John & Duke
* However, if firstName2 has no value, then
concatenatedName = "John" (without the "&")
A snapshot of my query grid is located at:
http://www.bigbridge.us/sql_issue.htm
Any help is MUCH appreciated.
Christopher