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 ?