I was wondering if I can add the UPPER () case to the following statement:
, MGNameAddressPhone.LName AS [Last Name], MGNameAddressPhone.LicenseNumber AS [Licence# (W/State)], MGNameAddressPhone.Passport, '***-**' & Right(Nz([SSN],'None'),4) AS [SSN# (last 4 only)] FROM MGNameAddressPhone"]