johnson1
asked on
Select fullname without familyname
Hello,
I have a table with names
UserTable(UserId int, Fullname(varchar(100))
Data:
UserId=1, Fullname='John Johnson'
UserID=2, Fullname='Bill William Howard'
I want to select Fullname from the table but not the last name.
From the example above I would like to get the result:
UserId=1, Fullname='John'
UserId=2, Fullname='Bill William'
Can you please help me with this?
I have a table with names
UserTable(UserId int, Fullname(varchar(100))
Data:
UserId=1, Fullname='John Johnson'
UserID=2, Fullname='Bill William Howard'
I want to select Fullname from the table but not the last name.
From the example above I would like to get the result:
UserId=1, Fullname='John'
UserId=2, Fullname='Bill William'
Can you please help me with this?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.