[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6347
  • Last Modified:

Conversion to upper case in Access Query Results

I know there is an UPPER and LOWER function in Oracle that can be used to convert text query results to all Upper case or Lower case for symmetry, but is there a function in Microsoft Access (SQL Server I guess) that can be plugged into the SQL to return the same result in queries on Access tables?
0
Stephen Daugherty
Asked:
Stephen Daugherty
3 Solutions
 
Rey Obrero (Capricorn1)Commented:
try
Ucase([FieldName])
LCase([Fieldname])
0
 
Kurt_BraeckmansCommented:
0
 
peter57rCommented:
If you are running the query in an Access application you can use:

Ucase(Fieldname)
0
 
messen1975Commented:
Ucase(String)
0
 
Stephen DaughertyAuthor Commented:
I received 3 replies all within the same minute with the same, correct solution, so I have awareded the points accordingly.

Thank all of you for the expedient response.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now