Stephen Daugherty
asked on
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ucase(String)
ASKER
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.
Thank all of you for the expedient response.