September 3, 2004 at 10:53 am
I have a table.
Field1
and want to create the view.
September 3, 2004 at 12:00 pm
create view myview as select field1 from tableA
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 3, 2004 at 12:17 pm
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
September 3, 2004 at 12:31 pm
CREATE VIEW YourView
AS
SELECT FirstName + ' ' + LastName AS FirstLast
from YourTable
--
Adam Machanic
whoisactive
September 3, 2004 at 12:33 pm
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply