SQLstatement results to UPPER case

Ernest Grogg
Ernest Grogg used Ask the Experts™
on
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

Comment
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

Author

Commented:
It is a sql statement in VBA, where would I place this in the statement?
Retired IT Professional
Commented:
Yes.
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