Concatenate parts of two fields

[haneen97]

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

 

[randysmid]

Hi,
I think you want to use the "Left" function, as in this:

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

Note that we needed to use two "left" functions. HTH,
Randy Smith
California Teachers Association