Avatar of Ernest Grogg
Ernest Grogg
 asked on

SQLstatement results to UPPER case

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

Microsoft AccessSQL

Avatar of undefined
Last Comment
Hamed Nasr

8/22/2022 - Mon
als315

If it is Access query, function is Ucase()
Ernest Grogg

ASKER
It is a sql statement in VBA, where would I place this in the statement?
ASKER CERTIFIED SOLUTION
Hamed Nasr

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck