SQLstatement results to UPPER case

Ernest Grogg
Ernest Grogg used Ask the Experts™
Hello everyone,

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"

Open in new window

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
If it is Access query, function is Ucase()
Ernest GroggSecurity Management InfoSec


It is a sql statement in VBA, where would I place this in the statement?
Retired IT Professional
In access, UCase$(MGNameAddressPhone.LName), returns a string
UCase returns a Variant.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial