Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106

    Unanswered: Conatenate parts of two fields

    Hi,

    Trying to concatenate the first letter of the first name and the first 7 letters of the last name to create a user naem. I am using the Mid$ function and getting a syntax error.

    SELECT UPPER(Mid$((First_Name,1,1) & "" & (Last_Name,1,7))) FROM users AS User_Name;

    Please help

    Thanks a lot.
    Mo

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150

    Re: Conatenate parts of two fields

    Try This

    SELECT UPPER(Mid$(First_Name,1,1) & Mid$(Last_Name,1,7)) AS User_Name FROM users;

    Machado

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •