January 27, 2005 at 11:09 am
Someone knows if there is something like multiset, to show more than one column under one column???
like
-----name----
at1--at2--at3
January 28, 2005 at 2:37 am
No, I never heard that there would be something like that in SQL Server. IMO this is presentational issue that should be done in the frontend, not through SQL Server. What do you need it for?
January 28, 2005 at 8:07 am
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."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply