military donut
asked on
SQLstatement results to UPPER case
Hello everyone,
I was wondering if I can add the UPPER () case to the following statement:
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"
]
If it is Access query, function is Ucase()
ASKER
It is a sql statement in VBA, where would I place this in the statement?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.