CONCAT_WS SQL Server Query creating a username

See more:

SQL

PHP

MySQL

MS-Access

I'm trying to concatenate items together with no spaces to create a username for my data output.

Below is the MS ACCESS query that will work in access. What adjustments do I need to add in order for it to run in MySQL? How do you concatenate the first initial, middle initial and last name in SQL. I just recently figured out the CONCAT_WS for creating a full name concatenate as you can see. Should I be using the same CONCAT_WS for the username? If so how do you get it to return the first initials?

"SELECT 
   			Customers.CustomerID, 
   			Customers.OldCustomerID,
   			CONCAT_WS( ', ',LastName,FirstName,MiddleName) AS CustomerName,


   			Left(FirstName,1)+Left(MiddleName,1)+LastName AS UserName,



   			zlu_Cars.Description AS Car, 
   			zlu_CarColor.Description AS CarColor, 
   			zlu_Computers.Description AS Computer,