All Roads Lead To Rome But Which One Is Most Desirable?

-- Business Rule, first name, middle name and last name can all be null
-- ddl
create table #cat (catID char(8) primary key, first_name varchar(15)
null, middle_name varchar(2) null, last_name varchar(15) null)

-- dml, populate sample data
insert into #cat
values ('Black123','ghost','','bigger')

insert into #cat
values ('Arab0123','Hama','','Abbas')

insert into #cat
values ('Mixed001','',null,null)

insert into #cat
values ('Mixed002',null,null,null)

insert into #cat
values ('Mixed003',null,'','Smith')

insert into #cat
values ('White123','','','Talley')

insert into #cat
values ('Yello123','Nick','H','Pisa')

-- dml, name concatenation, get all or any
select (first_name + ' ' + middle_name + ' ' + last_name) as name
from #cat
-- the above does not meet with requirement

-- option 1
select (IsNull(first_name,'') + ' ' + Case Len(middle_name) when 0 then
'' else IsNull((middle_name + ' '),'') end + IsNull(last_name,'')) as
name
from #cat

-- option 2
select (IsNull(first_name,'') + ' ' +
IsNull(NullIf(Coalesce((middle_name + ' '),''),''),'') +
IsNull(last_name,'')) as name
from #cat

q:
both option 1 and option 2 produces same result, which one is more
desirable?

TIA.