Home Forums SQL Server 7,2000 T-SQL Two fields into one RE: Two fields into one

  • September 3, 2004 at 12:31 pm

    #521710

    CREATE VIEW YourView

    AS

    SELECT FirstName + ' ' + LastName AS FirstLast

    from YourTable

    --
    Adam Machanic
    whoisactive