Post reply

multiset??

  • January 27, 2005 at 11:09 am

    #65339

    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

    #539484

    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

    #539544

    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