• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1182
  • Last Modified:

Simple SQL question.. URGENT!


 
I have a table with a first name and a last name column. What I want is to return only the last name if the first name is null, but (last name + ", " + first name) otherwise.

Any suggestions on how to do this without having to muck with a procedure? MySQL has a CONCAT_WS() (ws = with separator) function that does what I want, but I haven't been able to find any simple equivalent from Microsoft.
 
0
meixell
Asked:
meixell
1 Solution
 
DireOrbAntCommented:
SELECT LastName + ISNULL(', ' + FirstName, '') As Name
FROM ...
0
 
Anthony PerkinsCommented:
This is a duplicate question that exceeds the maximum 500 allowed. Please post a message in Community Support to have the points reduced in both threads as you have valid comments in both.  See here:
http://www.experts-exchange.com/Databases/Q_22035145.html
0
 
sajuksCommented:
something like ...
SELECT
    CASE WHEN fname IS Null and lname is not null then rtrim(lname)
    WHEN fname IS not Null and lname is null then rtrim(fname)
    ELSE rtrim(lname) +','+rtrim(fname)
end
FROM mytable
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now