The front end might not always be responsible ... here's a workaround, by no means elegant ...
create table name_info (
lname varchar(16) null,
fname varchar(16) null,
mname varchar(16) null,
)
go
insert into name_info values ('first','middle','last')
go
select '---name---'=fname+'--'+mname+'--'+lname
from name_info
go
drop table_name_info
go
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."