Tech_Men
asked on
combine sql column return null
hi
i have a table whit firstName and lastName columns
in my sql query i need to combine then like that
select lastName +' '+firstName as fullName
if one of the column are null i am getting null even i have a name in the lastName or FirstName col
how can i fix that ?
thanks ...
i have a table whit firstName and lastName columns
in my sql query i need to combine then like that
select lastName +' '+firstName as fullName
if one of the column are null i am getting null even i have a name in the lastName or FirstName col
how can i fix that ?
thanks ...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thx
Open in new window