Add two fields with space

  • How to add First and Last Name to one field as Name

    Select FirstName + Last Name as Name from tbl1

  • use SPACE(2)... or is this a trick question :ermm:

  • yulichka (3/4/2009)


    How to add First and Last Name to one field as Name

    Select FirstName + Last Name as Name from tbl1

    Select FirstName + ' ' + Last Name as Name

  • Select FirstName + ' ' + Last Name as Name from tbl1

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Thank you

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

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