rgb192
asked on
sql server column with firstname lastname
create a new table
where
[ShipFirstName] [varchar](100) NULL,
[ShipLastName] [varchar](100) NULL,
are in the same column separated by a space
CREATE TABLE [dbo].[names](
[id] [int] IDENTITY(1,1) NOT NULL,
[ShipFirstName] [varchar](100) NULL,
[ShipLastName] [varchar](100) NULL,
) ON [PRIMARY]
where
[ShipFirstName] [varchar](100) NULL,
[ShipLastName] [varchar](100) NULL,
are in the same column separated by a space
CREATE TABLE [dbo].[names](
[id] [int] IDENTITY(1,1) NOT NULL,
[ShipFirstName] [varchar](100) NULL,
[ShipLastName] [varchar](100) NULL,
) ON [PRIMARY]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I often do such concatenations in a view instead of building it permanently into a table.
ASKER
not a homework assignment
ASKER
thanks
With respect,
1) The structure of your question looks very much like a test/homework question and
2) Why would you even want to do that in the first place? It would take your nice, atomized data and destroy
its atomicity...
Regards,
Patrick