Two fields into one

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 1

SSC Guru

Points: 736479

September 3, 2004 at 12:00 pm

create view myview as select field1 from tableA

Gold-158597 SSC Enthusiast Points: 185 More actions · Answer 2

I am Sorry....... The table has two fields; Last Name, First Name.

In the view I want Last name and first name into one field.

Thanks

Adam Machanic SSCoach Points: 15370 More actions · Answer 3

CREATE VIEW YourView

AS

SELECT FirstName + ' ' + LastName AS FirstLast

from YourTable

--
Adam Machanic
whoisactive

Gold-158597 SSC Enthusiast Points: 185 More actions · Answer 4

SSC Enthusiast

Points: 185

September 3, 2004 at 12:33 pm

Thanks